Insights (Business Reporter and Analysis Models, EOI)

After we installed the new version of BR 5.0.19.0 ,one particular user gets the error “IFS BR Upgrade Utility is not installed” while loading any report..This doesn’t stop the report from loading though..IFS BR Upgrade Utility is in fact installed and we upgraded the reports using that ..Tried uninstalling and reinstalling several times,however no luck..Appreciate any info on this ...

We are using App 9.4. We could not visualize the line chart with comma separation. We tried many types of data sources. It did not affect anything. In the pie chart, everything works fine. We tried to_number, round while getting data but still the same. How can we visualize with comma separation?  

Hi all.  I’m new to using SSRS for Operational Reports.   In trying to develop a new report, while trying to preview the report in Visual Studio, I receive the error “Cannot set the command text for dataset ‘dsQuoteFromContract’”   Has anyone else received this error?  What did you do to correct it?  Thank you in advance.

Basics:Navigate to ‘Lobby Data Source Designer’ and click + then select ‘Query Builder’. Add a name for the data source. Finding a view:Under ‘Search Views’, search Instant invoice. All the columns and references related to instant invoice will list down.  Adding a column and a function:RMB on ‘Invoice No’ and select ‘Add to Columns’. Then the column will appear under the columns section. Perform the same steps for the function ‘Get_Address’. Then search the view ‘Ledger Item’ and add the column ‘Cleared Amount’ as well. Adding a where condition:RMB on ‘Invoice Id’ and select ‘Add to Criteria’. Select the operator as = and insert a selected invoice id. Adding a table join (Inner):Under the joins section, select the Left View as ‘Instant Invoice

I can see different user in my company when they access the Reporting/Ad-Hoc Reporting they can see Explore Quick Reports. However, I can see others do not see the Explore Quick Reports options.When I try to see the data Source I found tbwQuicReportsListWhen I go to the Presentation Object Grants I can see the Permission Sets granting ‘Quick Reports’Permission Set FND_ENDUSER  However, all the user in my company have FND_ENDUSER, Why other can see Explore Quick Reports and why other cannot see Explore Quick Reports?How can I make Explore Quick Rep

Help! I’m new to report rules and I want the company and the customer to decide what print layout to use. I’ve created simple one expression rules that work but I’m struggling to get two expressions to work. Below is what I’ve written and the error message I’m getting. If anyone can guide me that would be very appreciated. 

Hello,I am getting following error on starting the IFS BR Server. IFS BR Execution Server (IFS BRES) cannot run in parallel with IFS Business Reporter (IFS BR) on the same host. Please make sure to uninstall IFS BR before starting IFS BRES. IFS Business Reporter is not installed on the server. I have removed related any registry entry for the sameis there any advise RegardsPankaj

How can I install IFS BR add-ins on App10 upd8?

Hi ,I have BA client version  4.0.22.0 and Excel 2016 in one of the customer environment.And getting the following error when trying to open a published BA report from BA client.Full Details:System.NullReferenceException: Object reference not set to an instance of an object.   at Ifs.Application.ExcelReporter.ReportDesigner.ReportParameter.GetXlrTemplateParameter()   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.SetTemplateParameters(XlrTemplate template)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.DefineDsodDataSets(Int32& setCount, ArrayList& physicalDatasets, Boolean cacheEnabled, Int32& lastDataSetId)   at I

Hi,I am new to Business Report and trying to add a new custom attribute ‘sub_project_id’ to FACT_GL_TRANSACTION but not working ! wondering where is my error …select Sub_Project_Id from activity a where a.project_id = :project_id and activity_seq = :activity_seq  Any suggestion is much appreciated … Thanks

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.