Insights (Business Reporter and Analysis Models, EOI)

Hi,With Quick Information sources, by default, it creates OL view. Is it possible have a DM version as well, similar to standard information sources?Thank You & Best Regards

Does anybody know a reason why a Business Reporter report does not get processed by the BR Execution Server? Other BR reports do get processed by the BR Execution Server.The  BR report we have a problem with doesn’t even appear in the BR Execution Server logs? Any ideas.

Hi All,I have a Materialized View which I need to use to create a QIS. Can I know if this is possible in IFS?    If So, what re the steps please?Thanks!

Is there a way to copy an existing Business Reporter design and copy design sheet into another existing BR excel spreadsheet (two separate files)?

Upon login it throws the following error (Office 365)“This Add-in is installed for all users on this computer and can only be connected or disconnected by an administrator” The addin IFS Applications don’t show up in excel Can you help please ? Thanks Shibu

When we run our BR reports we are getting the following error message appearing on the IFS Business Reporter execution Server Console: Failed to start Excel Application , Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). ,  Template rendering Exception:  Object reference not set to an instance of an object., . Error not related to report design. Therefore report not saved to error folder. Last successful execution log entry: Failed to start Excel Application , Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). , Does anyone know how to resolve this issue?

Hi,  If IFS will continue to support on IFS EOI? kind Regards,Aida.

Hi All, I’m creating a List element to show the intrastat rate on our lobby. The data source is to 4 decimal places, however the list element is defaulting to 2 decimal places. Is there a way to change this as we really need to have 4 decimal places on the lobby? The navigation to source data is being turned off as we don’t want everyone getting into the financials of IFSThe preview image of the elementThe data source details 

Hi Everyone, I was wondering if anyone could guide me this, I wan to print customer order confirmation when an order is released I also want it to be printed to a specific printer  Thank you in advance 

thread needs to be closed.

When trying to refresh 3 data mart sources either individually or together  we receive the following message:Error while refreshing Data Mart Source (CONSOL_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expiredError while refreshing Data Mart Source (CONSOL_PER_DET_BAL_MVT) - resource busy and acquire with NOWAIT specified or timeout expiredError while refreshing Data Mart Source (CONSOL_PERIOD_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expired At the time of refreshing I was the only one logged int. Regards John

I am trying to right a business reporter report using a custom IAL information source.  I want to be able to zoom in on the data driving the summary numbers in the report but it is greyed out in the design area for the measured item.  Does anyone know if a zoom in can be performed on a custom IAL information source?  

Hi, I want to use the Information Sources Supplier/Customer Open Balance, but Business Reporter is not showing data when I run the report. I tried adding various data items, but not one is showing data. Has anyone else experienced this problem and/or knows what the issue is and how to solve it?  Kind regards,Simon 

Trying to refresh FACT_CONSOL_BALANCE and receiving the following error: Null value not allowed:  (ORA-01400: cannot insert NULL into (“IFSAPP”.”CONSOL_BALANCE_MVT”.”BALANCE”)  Any ideas how to resolve this issue. Thank you.

Hello,I designed a lobby element in IFS. I cannot show 3 months of daily data on a graphical lobby screen.Incoming report data shows 60 days but only 40 days.If there are two graphics data, fewer days are returned this time.Is there a limitation of lobby values ​​within IFS?   In the example below, there is data from 01.09.2020. If I make 01.09.2020 to 01.08.2020, the graphs do not show all the data.   

I have a SSRS report that I created. However, I do not know how could I connect the report to IFS? any set up in IFS ? I am currently using IFS 9 

Hi, I am new to Business Report ...my Business Report is using data from GL Transaction. I need to list ALL the cost element linked to each activity. Is this possible to generate data from many information sources into 1 sheet?when I tried to add a custom attribute to GL transaction , it is just returning 1 value ! same result when I try to add my custom attribute as repeater .Any suggestion will be much appreciated 

Our company would like to take advantage of printing media items on the service reports using Report Designer.  Our solution is  hosted and part of the challenge has proven to be obtaining access to the RDF files so that they can be changed. This is standard functionality on some of the other reports such as order confirmation but not the service reports.  Ideally, this would become standard functionality so it is not our responsibility to maintain this as upgrades come.  Has anyone had any success modifying the RDF files in a hosted environment.  It seems to have stumped support based on the feedback I have received.

Hi, I have an issue with adding a field on a lay-out in Report Designer. I want to add a field on the pdf lay-out of the Customer Invoice, but two tables overlap in Report Designer with as result that I am not able to add the new field. Does someone know how to resolve this issue? Please refer to the screenshots below.    

Trying to refresh a Data Mart Source and receiving the following error: ORA-20110: Error while refreshing Data Mart Source (CONSOL_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expired    How do I debug/resolve this issue?

Can anyone share example reports of BR with writeback in project forecasting? How to add all ETC column in write back?  Is it possible to writeback of a entire row as new entry using writeback?  

Hi, I am trying to extract the weeknumber from a date. But both my SQL statements return the wrong weeknumber. Here is my first statement: SELECT to_char(to_date(cf$_co_date_order, 'dd-mm-yyyy'), 'ww') FROM customer_order_cfvStatement returns: 22-3-2021 0:00 12 23-3-2021 0:00 12 24-3-2021 0:00 12 24-3-2021 0:00 12 25-3-2021 0:00 12 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13  My second statement: SELECT to_char(to_date(cf$_co_date_order, 'dd-mm-yyyy'), 'iw') FROM customer_order_cfvStatement returns: 22-3-2021 0:00 12 23-3-2021 0:00 12 24-3-2021 0:00 13 24-3-2021 0:00 13 25-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13  So both are wrong. I expect every date to return weeknumber 12, because that is the correct weeknumber. Does someone know how to achieve this? 

Hi, I created a Custom Field in the LU IncomingInvoice which returns the Coordinator Name based on the PO Reference. But there could be multiple PO References separated with a semicolon. When that is the case IFS returns no value. Is it possible to solve this issue, so that IFS returns multiple values when there are multiple PO References. Please see the screenshots below. Arguments:v.company, v.po_ref_numberSelect Statement: SELECT t.cf$_coordinator_name FROM Purchase_Order_cfv t WHERE t.company = :COMPANY AND t.order_no =:PO_REF_NUMBER Kind regards,Simon

Hi, I want to create two custom fields in the menu Supplier Invoices Analysis (view = INCOMING_INVOICE2) and need some help:A Custom Field which shows the On Hold Reason (SQL Column: on_hold_reason) from the menu Authorize Invoices for Payment (view: PAYMENT_PLAN_AUTH_QRY). A Custom Field which shows the Coordinator (SQL Column : AUTHORIZE_CODE) from the menu Purchase Order (view: PURCHASE_ORDER). Can someone please assist me and help me get the right statements to create both custom fields?Kind regards,Simon

I äm trying to create a new lobby for Project Hour and Cost Analysis hence I have created the below sql query but I am finding it difficult to have a sub-total for every group of the same activityI wrote the following SQL query  select distincta.activity_description,a.resource_id as resource_id,b.resource_group_desc,a.qty_used as qty_used,a.qty_planned as qty_planned,a.project_cost,a.percent_usedfrom IFSAPP.activity_resource_proj a JOIN IFSAPP.activity_resource_proj_sum bON a.resource_id = b.resource_idAND a.project_id = '&Project_ID'ORDER BY activity_description Below is what I am gettting:I need a sub_total for Activity named 'DETAILED DESIGN’ as well as sub_total for '’ÍNSTALLATION SAFETY STUDIES'’