Skip to main content

Insights (Business Reporter and Analysis Models, EOI)

This will include the questions related to Business Reporter and Analysis Models, and Enterprise Operational Intelligence.

  • 661 Topics
  • 1,885 Replies
661 Topics
J
Hero (Customer)
JoDeHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Microsoft Fabric connection with IFS

Does anyone know if it's possible to link the IFS database to Microsoft Fabric?https://learn.microsoft.com/en-us/fabric/database/mirrored-database/open-mirroringWe're currently using the self hosted bi, but I can't say that's a perfect solution so we're looking for better alternatives.

532
J
Hero (Customer)
D
Do Gooder (Customer)
DanielCatoioDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Lobby - Block automatic refresh

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

201
Charana Udugama
Superhero (Employee)
N
Hero (Customer)
NMALKIHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Why Functional Parameter not visible

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 

221
ChanakaEA
Do Gooder (Partner)
SureshBandara
Sidekick (Partner)
SureshBandaraSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Changing Date Format in Quick Report Parameters

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.   

923
T
Do Gooder (Customer)
N
Hero (Customer)
NMALKIHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
QR Schedule Failed - ORA-06512

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

7486
N
Hero (Customer)
D
Sidekick (Customer)
dritterSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Business Reporter Login Error

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.GetOpenIdAccessToken() at Ifs.Application.Br.Authenticator.Se

43110
Dinushi Liyanage
Hero (Employee)
M
Do Gooder
Mustapha_DeublinDo Gooder
asked in Insights (Business Reporter and Analysis Models, EOI)
list of tables and schema of IFS ERP database

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 

532216
A
Do Gooder (Customer)
H
Do Gooder (Customer)
HAFARDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
How to log into Power BI Sample Reports

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? 

261
S
Hero (Employee)
K
Do Gooder (Customer)
KatarzynaPraeDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Assyst Report for Incidents

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 mentioned at the beginning? Thank you very much in advance for your help.

80
K
Do Gooder (Customer)
Marcel.Ausan
Ultimate Hero (Partner)
Marcel.AusanUltimate Hero (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Schedule Business Reporter report - application message failed

IFS Cloud 23R1 SU4I’ve tried scheduling a Business Reporter report with the scheduling functionality introduced in 22R2.I’ve noticed the following:3 application messages are created for below settings the first 2 app messages I understand what they are and I get the email for these notifications The 3rd application message fails with NO ROUTING RULE FOUND. Also the input message only refers to data from report Archive.Does anyone have any idea how is this supposed to work? I don’t wanna have failed application messages. I could create a Routing Rule to catch this message and don’t do anything with it, but I’d like to understand what’s the purpose of the 3rd application message. 

662
Furkan Zengin
Ultimate Hero (Partner)
C
Sidekick (Partner)
Christophe BUSSISidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
How to access to IFS data from POWER BI

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  

27686
W
Sidekick (Customer)
M
Do Gooder (Customer)
MhughesDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Standard Quick Reports

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!

352
M
Do Gooder (Customer)
Madura
Do Gooder (Partner)
MaduraDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Business Reporter Error When Opening Saved Excel File

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? 

863
Madura
Do Gooder (Partner)
H
Do Gooder (Partner)
himasha.abeywickramaDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Data Mart : Stop Previous Refresh Job

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?

594
S
Hero (Employee)
D
Sidekick (Customer)
DV - JLSidekick (Customer)
posted in Insights (Business Reporter and Analysis Models, EOI)
Business Reporter - Dynamic Rolling 12

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 the report to give me all of 2024. Example, if ran for March 2025, I will have 3 December 2024’s, 1 wanted and 2 extra columns, due to the filters of =2024 and 2 YearPeriods behind 202505 is January 2025. Any thoughts/suggestions/ideas/constructive criticisms are greatly appreciated!

275
T
Hero (Partner)
S
Do Gooder (Customer)
sonerDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS report designer for .rpl files

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

181
T
Hero (Partner)
B
Sidekick (Customer)
BEYJASONCHANSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Cannot export a Business Reporter report to save as an excel file

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, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object L

140
B
Sidekick (Customer)
B
Sidekick (Customer)
BEYJASONCHANSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Cannot export a Business Reporter report to save as an excel file

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, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object L

190
B
Sidekick (Customer)
A
Do Gooder (Employee)
adamsmithDo Gooder (Employee)
asked in Insights (Business Reporter and Analysis Models, EOI)
Export Quick Report as .csv or .xml (IFS Cloud)

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. 

7743
A
Do Gooder (Employee)
S
Do Gooder (Customer)
SnehaGDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Extra Spaces in Excel Attachment for Scheduled Quick Report

 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 attachment?Is there a specific setting related to the export format that might be causing these spaces?Any other suggestions to resolve this issue? Thank you!

785
FrançoisG
Do Gooder (Customer)
D
Do Gooder (Customer)
Dekforce94Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
DOP HEADER ERROR

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 

190
D
Do Gooder (Customer)
Himasha Abeywickrama
Superhero (Customer)
Himasha AbeywickramaSuperhero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Dynamic conditions for an Entity Criteria

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 

191
S
Hero (Employee)
D
Do Gooder (Customer)
Dekforce94Do Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
INVENTORY COUNT REPORT

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?   

311
Vimukthi Mahakumbura
Superhero (Customer)
A
Sidekick (Customer)
athasankaSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Power BI vs Business Reporter

Hi all, With Crystal Reports being deprecated, was weighing the alternatives available for regular users to create business reporting. Anyone who has used both Power BI and Business Reporter, what are your thoughts? How do they compare against the visuals, limitations, configurability, integaration with IFS, access etc.I know Power BI will need premium licensing and will have to host the reports on a workspace for them to work.

230
A
Sidekick (Customer)
M
Hero (Customer)
MMcKHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Custom package API procedure usage in IAL

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?  

453
PhillBronson
Hero (Customer)

Badges

  • 1st Reply
    fishpolehas earned the badge 1st Reply
  • 1st Topic
    Selmahas earned the badge 1st Topic
  • 5th Reply
    emma_buyerhas earned the badge 5th Reply
  • 10th Reply
    cmojkuuhas earned the badge 10th Reply
  • 5th Reply
    yoderkdhas earned the badge 5th Reply
Show all badges
Terms & ConditionsCookie settings