Insights (Business Reporter and Analysis Models, EOI)

Hello,I’m having a problem where Custom Field data is not getting transferred over to SQL database. Here’s what i have done,1. Relations for Facts      2. Custom Attributes for Facts  3. Access View  4. Data Source  5. Deploy to SQL Server Db6. Data Load Run

BR Reports refuse to be rendered as a PDF although these settings were done:  There was an issue with PDFs which should have been resolved by BR version 23.2.0 (EIZBR-2617), but I am using version 24.1.1 in this case and still I am getting would-be PDFs as ordinary Excel workbooks.

when i add a new table to existing layout , the table doesnt appear in preview online. could anyone explain why?

HI everyoneI would like to know if it's possible to block the automatic refresh of a specific lobby.I know that we have the option to refresh automatically but I would like to opposite as I have some lobbies which are quite heavy and we would like to get refreshed only on user demandFYI, we are using IFS 10 Update 9 Thanks in advance

Hi Team, Would really appreciate your advice here. I create  Functional Parameters  but they are is not showing in my BR whatever I try :(Yes I am connecting to same Environment, I refresh ALL Information Sources in BR Functional Param don’t get publish from memory I even duplicate an existing Func Param  but still the new one doesn’t appear. only the old one is visible in BR I even restarted my Laptop … Crazy isn’t it what am I missing here ?  Thanks 

Hi everyone,I have a request from a customer who needs to adjust the date entry format in Quick Report parameters. This is a Crystal-based Quick Report, and they want to enter the date in dd-mm-yyyy format. However, when attached to Quick Report, it prompts for yyyy-mm-dd instead. The report itself is designed to read the date in the required dd-mm-yyyy format, but the Quick Report interface enforces a different format.Has anyone encountered this issue before? Is there a way to modify the date format for Quick Report parameters inside IFS Application?Any insights would be greatly appreciated!Thanks in advance.   

Hi Community, I am trying to Schedule Quick Report. It failed with below error‘The directory id MY_USERID is not allowed to run the application.ORA-06512: at "IFSAPP.ERROR_SYS", line 140ORA-06512: at "IFSAPP.ERROR_SYS", line 341ORA-06512: at "IFSAPP.LOGIN_SYS", line 329ORA-06512: at "IFSAPP.LOGIN_SYS", line 136ORA-06512: at line 1” Just to mention that I got IFS_ALL permission and I can also run the QR in the frontend. I tried other QR also without success.When I change “Execute As” to ‘System’ it also fail with a different error ‘Entity instance not found. (QUICK_REPORT - QUICK_REPORT_ID=813974.0)’.Also to mention that we are on APP10 update 15.Much appreciate your help

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? 

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

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