Insights (Business Reporter and Analysis Models, EOI)

Report Filter for Structure Nodes using “BETWEEN” Operator for IFS Business Reporter adds extra data. “IN” Operator works fine. “BETWEEN” Operator works fine only for the Integer Data

Hi everyone,We are currently running the setup script for the Script-Based Infrastructure setup in Azure for Self-Hosted BI. Everything worked smoothly until Step 3, where the general function tried to locate the params.json file in the following path:C:\Windows\system32\templates\…  Has anyone encountered this issue before or knows how to get params.json file?Any guidance would be greatly appreciated.Thanks!

The documentation states the following, but I cannot find where to download the Layout Migration Tool in the Remote Deployment Guide.Can anyone tell me where I can download the Report Layout Migration Tool?https://docs.ifs.com/techdocs/24r1/070_remote_deploy/400_installation_options/005_operational_reporting/150_layout_migration_tool/--> https://developer.ifs.com/  

We are currently upgrading from Apps10 to IFS cloud . When trying to replicate one of our IAL’s  in IFS Cloud  we noticed some of the called functions in Purchase_Order_Invoice_API are missing when cpmpared to Apps10 e.g. Purchase_Order_Invoice_API.Calc_Invoiced_Unit_Price is no longer present in 24R2. Is there anywhere I can check to see if/when this was deprecated and what the alternatives for these missing functions are?

Hello!I am trying to create a new query with Cloud Query Designer to show orders for a certain sales group that were invoiced “Today”. I added a filter the the Customer Order Invoice date - but I can’t figure out how to set it as a dynamic value for “TODAY”. I’ve tried setting it as a Parameter as well, but then the query prompts me to enter a date to preview the data. This won’t work for us as the intent is to schedule the report to be emailed to a group of users on a daily basis. Is this possible to set the invoice date as a dynamic value of “TODAY” with Query Builder? I’m a novice at query building so any tips someone may have a greatly appreciated.  

I have noticed some views used for data sources (Parquet Files) get delivered without any row data once they land in our ADLS gen2 storage. CUSTOMER_ORDER, PURCHASE_ORDER for example. Other views work absolutely fine - seems to be hit or miss. Does anyone have any idea why that would be the case? I copy the query used by the data pump job into a quick report, and it returns data just fine. Is there a specific account running the job that I can check/update its permissions?

 During the internal setup of IFS Cloud 25R1 Script-Based Infrastructure for Self-Hosted BI, the infrastructure deployment in Azure was completed successfully as per the documentation. However, the user was unable to locate the System Parameters page under Analysis Models → Power BI in IFS Cloud Web https://docs.ifs.com/techdocs/25r1/050_reporting/010_analytics/010_analysis_models/010_am_pbi/000_biinfrasetup/100_ampbi_infra_setup_s3/#3_update_setup_parameters_in_ifs_cloud_web

I need to add an e-signature to the end of the Purchase Order report. I created a report rule and there is an option to specify the page number on which the signature should appear. However, I want the signature to appear on the last page, and since the total number of pages may vary, I cannot specify an exact page number. Is there a solution for this?Below are the report rule action properties I’m currently using 

I get below error when I open IFS Business Reporter. Any suggestion/ solution is highly appreciated. 

Hi,I have created a custom field in IFSAPP10 but it is not displayed in IFS Report Designer.Enabled On Reports tick box is ticked as well. Can anyone help me to get the custom field to the IFS Report Designer. 

Starting on July 13, 2024, our data loads started having issues.  We did not have any patching or updates or changes that I can find. Prior to this they were running successfully since deployment for over 6 months. The data load itself has a status of executing with errors.  Each data source shows as Executing, Failed, Success or Submitted.  Most were showing as Submitted.  The BI server errors looked like they were deadlocking them selves.  I put sequential IDs and sequences on all of the data sources and now most show as Success. If I run a data source by itself, then there are no issues. Any help or ideas would be great. Here is the IFS screen examples:  H

Hi all, I try to log-on to Business Reporter, but I face strange error, which I have never met before: When I click “Refresh the page.” I get this error: I have installed this website’s certificate and this environmental works in browser correctly. I have also prepared IAM Client as it should: I have done this several times before for different environmental, and I have faced an errors when IAM Client or certificate is not defined correctly, but now I have done and defined them for this environmental at lea

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.

19:32:43 INFO - REQUEST method "POST"19:32:43 INFO - REQUEST uri "https://===========/main/ifsapplications/projection/v1/PrintDialog.svc/ReportDirectPrintRequest?odata-debug=json"19:32:43 INFO - REQUEST protocol "HTTP/1.1"19:32:43 INFO - RESPONSE status {"code":"500","info":"Internal Server Error"}19:32:43 INFO - RESPONSE headers {"OData-Version":"4.0","Content-Type":"application/json"}19:32:43 INFO - RESPONSE body "{\"error\":{\"code\":\"DATABASE_ERROR\",\"message\":\"Database error occurred. Contact administrator.\",\"details\":[{\"code\":20105,\"message\":\"ORA-20105: Report.PRINTJOBERR: Error occured while running the Report. Refer to Print Manager/Print Key 232\"}]}}"19:32:43 TRACE - SERVER version "odata-server-core Version 4.9.0.1-ifs"  when try preview purchase order before print always 500 internal server errorany solution?

Hi I am getting this error message in Aurena “Invalid datasource definition”  and not in IEE. I checked permissions for both the design and source element and all the permissions were granted.   

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.

how to fix certain fields to be displayed in second page ? in IFS Report Designer

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