Insights (Business Reporter and Analysis Models, EOI)

Hello,We have an issue surrounding business reporter that is causing frustration in its users. After initial login in Excel, we are able to use BR as needed. However, if we get timed out and attempt to login again, we get the error below. The only workaround we’ve found involves closing all instances of Excel and reopening the business reporter. This is a pain when working on many reports, or when we just have many different documents open. Occasionally this doesn’t even fix the issue and we need to restart the entire computer. Is anyone else experiencing these issues with BR? Anyone have a fix for it? Thank you,Dylan************** Exception Text **************System.Exception: Error while calling the projection BrClientAuthorizationHandler. ---> System.Security.SecurityException: IFS Business Reporter session has expired. Please re-login using the Login button. at Ifs.Application.Br.Authenticator.AuthenticatorService

Hi everybody ,I’m new by using IFS ERP and as Data analyst I need the list of tables/views and also the relationship between tables (Foreign keys ) like the Schema  !Regards 

Hi,I want to log into the IFS Power BI Sample Reports using my company email:However, I encounter the error as attached below. Does anyone have a solution to fix this issue step by step? 

Hello,I am trying to create a reports using Assyst. Information I need is:Number of tickets in a given month Distribution of tickets among individuals Average time to resolve a ticket How many are currently open and since when.I started with the simple Event Monitor using a query providing all Incidents from the beginning of this year, however the chart for some reason provides data only until February.I am using Date/time logged, where below you can see I have a data from e.g. july this year:  And the chart provides this: Any idea why?And also how else I could get the report providing me all details I had ment

Hi,We use IFS Cloud 21.2.11 on Managed Cloud and Power BI desktop connect to Power Bi Cloud.Is it possible to read IFS data from Power BI ?If yes, do you have a documentation ?Regards, Christophe  

Hello,I am curious if IFS comes standard with any Quick Reports that a client would get when they purchase the ERP, or if all Quick Reports need to be created by the client. We have a list of dozens of Quick Reports in our system, and I’m wondering if any of them came standard out-of-the-box or if we made them all/had them all made for us.Thank you!

I encountered an issue when opening a report generated from the ORDER REPORT screen in IFS Business Reporter. When I open the saved Excel file, I get the following error message: (We found a problem with some content in [report id]. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.")After clicking Yes, the report opens, but I'm unsure what caused the error or if the content is affected.Has anyone experienced this before or know what might be causing it? 

Hi,I’m getting following error when trying to activate a data mart,The following error occured while refreshing Information Sources; "Error while refreshing Data Mart Source (GL_TRANSACTION_MVT) - resource busy and acquire with NOWAIT specified or timeout expired"Is there a way to stop the previous job?

Anybody ever created a dynamic rolling 12-month report in Business Reporter for balance sheet items (including the Period 0 activity)? I’m running into issues, and wanted to know if someone had a better idea or an idea to tweak what I have. I have 23 column designs. The first is for the wanted YearPeriod. The next 11 are “previous YearPeriods within the same year (currently filtered to 2025)”. The next 11 columns I’m attempting to have the same conditions, but in the previous year (again, filtered to 2024). When I run the report for January, it’s perfect, it gives me 12 different months. For every month past January, it gives me an extra “December”, as my current filtering is telling t

Hello , I have excel layout with .rpl extension ,is there any method to redesign this document and add some features. 

After the Windows 11 update I can't export in Excel an IFS Business Reporter file.I usually go to the 'Manage Reports' function in the tool bar and then "Export" the report. Which then saves the file as an excel file.I have been using this method successfully for years until my laptop has gone through the Windows 11 update. I am now receiving the below error message: Any idea how to resolve this issue? Thanks The error details as follow:System.Runtime.InteropServices.COMException (0x800A03EC): Excel cannot open the file ’tmp30AB’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.   at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Ob

After the Windows 11 update I can't export in Excel an IFS Business Reporter file.I usually go to the 'Manage Reports' function in the tool bar and then "Export" the report. Which then saves the file as an excel file.I have been using this method successfully for years until my laptop has gone through the Windows 11 update. I am now receiving the below error message: Any idea how to resolve this issue? Thanks The error details as follow:System.Runtime.InteropServices.COMException (0x800A03EC): Excel cannot open the file ’tmp30AB’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.   at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Ob

In Apps 10 there was an option to export data, including the output of quick reports, in various different formats. By default this included .xlsx, .xml and .txt (which would be formatted as a CSV) as well as there being a setting to enable more possibilities. Is there similar functionality available in IFS cloud? When pressing the export button it does not give a choice and always exports as a .xlsx. 

 Encountered an issue when running a scheduled quick report in IFS Cloud 24R1. When the report is sent as an email attachment in Excel format, it contains extra spaces around the cells (except for the header row). However, when I run the same report and export it directly from the quick report/output window, it appears correctly without these extra spaces. Example - Scheduled quick report mail attachment: Output from Quick report window:Could you please guide me what configuration settings should be adjusted to prevent the extra spaces in the scheduled reports Excel attach

Greetings!Trying to create a structure of a DOP but get the following error. What does this mean? How do I fix it?IFS APPS 10 

Hi,Is it possible to use a dynamic expression such as TRUNC(SYSDATE, 'IW') - (7*52) - 1 as a condition value for an information source entity criteria? Trying to add this for ITH_DATE_CREATED in FACT_INVENT_TRANS_HIST information source but i get below error when trying to click on save,Invalid date (TRUNC(SYSDATE, 'IW') - (7*52) - 1) defined for item FACT_INVENT_TRANS_HIST.ITH_DATE_CREATED. The date format should be YYYY-MM-DD HH24:MI:SS 

Greetings!When I perform an Inventory Count Report, I get a part number that is located in different spots that is printed on one sheet each location it is in. Is there a way to consolidate the report that way I don’t get 80+ pages of the same part number on 80 different locations on 80 separate pages on Apps 10?   

Hi,I’m trying to call a custom API from an IAL in IFS Cloud.  The procedure is in a custom ‘develop on the inside’ utility package written and deployed from IFS Developer and works fine when called from projections.  The IAL also works fine if a standard IFS API procedure is called.I have added IFSAPP. prefix to the procedure call in the IAL query and as a result of this Community question I’ve also tried the @AO.. prefix (although that seems to apply to APPS10).Either of these result in the background job getting stuck in ‘Executing’ with progress shown as ‘Copying data’.I have also granted execute privilege on the package to IFSINFO.Is there something else I need to do to get the IAL to populate?  

Hi when publishing Business Reports in to IFS Cloud there is no possibility to categorize the reports.I would like to have the possibility to at least set the Domain or Category.Is it possible somehow to amend the list of Domains and Categories in the Order Report program?

How to upgrade IFS browser to accomodate MS 365 sites ? Thanks

I need shop order note_text field to appear in project database.What’s the API (&AO.SHOP_ORD_API) to get NOTE_TEXT in shop order ? Thanks

I want IFS notification send through email.How do I do that ? Thanks

how to add a view to Modules_rep in an existing RDL file in Report Designer? Have to add a new field from a new view than the existing view (barcode_lines) in the rdl file (report to register arrivals ) 

Hi,is there any way to achieve this in Business Reporter?SELECT MAX(result_seq_no) We run a job several times each month, generating values for our projects. Each time, the results are logged it creates a new result_seq_no., I only want to fetch the highest (newest) sequence for my projects into my Business Reporter report. Eks data in IFS Cloud:Project result_seq_no Values A 1 1 A 2 2 B 3 1 A 4 5 B 5 3  When fetching to Business Reporter, I want this:Project result_seq_no Values A 4 5 B 5 3

Since upgrading to Windows 11, we have been experiencing problems re-opening reports/files that have been generated using IFS Business reporter excel add-in with APPS10. Has anyone else had this error and been able to resolve?This error is received when no other files are open etc