Insights (Business Reporter and Analysis Models, EOI)

Hi , We crated Data load run definition for IFS_EMPLOYEE_ANALYSIS Tabular model and getting below error. SSIS LOG We noticed that the ID defined in the DIM is created with Company^Structure ID^Code^Valid To.But IFS oracle database can have multiple records for above combination and this caused the error in Data load run. Can we add parent_org_code into the below ID to make this a unique record? Tried to add Parent_ORG_CODE using below window and it is not available to add as the 5th Dimension ID Many thanks for your inputs on this issue. Best regards, Uvini

Hi, In Apps10, there was a possibility to add a custom menu to open a Business Reporter reports as below. When the action type ‘Report’ is selected, BR reports are also available to select. However, in IFS Cloud, when adding a command through page designer, BR reports are not listed under any of the report types. Is there any other way to fulfil the requirement of opening a BR report from IFS Cloud, via a button, link or by any other mean except through Order report? Best Regards,Nisansala

Is it possible to export reports created using IFS Business Reporter as .ins files? I noticed that the sample reports in General Ledger are delivered as .ins files. But I could not find a way to do that using IFS Business Reporter. Any idea how to do this?

Hi all I am trying to grant access to a user to run a specific quick report we built. But it seems to me that if I grant FND_QUICK_REPORTS to him, she getto run all the Quick reports. is that correct? What's the best way to give access? I am missing the presentation object I used to have in IFS10. This is 24.1.1 by the way. Thanks,Asela

Hello community, I am trying to install BR for APPs10 through the MSI file, but the following error message is displayed I can’t see nothing in my folder IFS Aplications related to ClickOnce version Also I have disable the COM Add ins just in case. I want to uninstall the CLickOnce and re-install BR through MSI file. THanks and regards

Is there a way to restrict list of values on report parameter in business reporter ?

Hi All, I am planning to migrate IFS Business Reports created for Apps 10 to IFS Cloud. Here’s the process I followed so far: Downloaded all the reports from IFS Apps 10 and saved them on my computer. Opened the reports in IFS Business Reporter for Cloud and attempted to save them. However, I encountered the following error during this process: I would appreciate it if you could help me resolve this issue. Additionally, I would like to confirm if this approach for migrating reports is correct, or if there’s a better way to proceed. Thank you for your support! Deepal.

Hello community, When trying to navigate to source from GL Balance Drill Down, it is trying to navigate to below path. I have read other posts on the community saying that BR system parameters must be set up with URL etc. However the parameter is removed from the page. I have read BR system parameters on the online documentation and it says basically the parameter is moved to system parameters and must be entered there. https://docs.ifs.com/techdocs/24r1/050_reporting/256_br_and_a/030_business_reporter/032_br_configuration/021_br_system_params/#url_navigation When I check the System Url parameter on the mentioned page the value is correct. Do you have any suggestion or alternative solution? The version is Cloud 24.1 Thanks

Dears, Is there possibility to manage the permissions for the sources in Business Reporter? For instance, Person A (from Purchase Department) should not be able to create the reports from Finance, HR area which contains “sensitive data”. I would be grateful for any information how we can manage the permissions in this area? Best regardsMateusz

Is it possbile to remove / delete old reports from the database? Having tested various things in BR, there are now many unwanted reports visible. How would one go about removing or deleteing them?

Hello, How do I refresh a QIS, the ial that it is based on has 12000 but the QIS has only 10000 records ? Thanks

Evening i am looking for SQL help with my quick report. I’m pulling a date column in which i am truncating to split out the time. I want to create a selection box for the user to put a from and to date allowing a range to be displayed. Would it be easier to pull a single selection box which the user can use the between dates function? i’m starting with AND TRUNC(PROMISED_DELIVERY_DATE) BETWEEN DATE '2023-06-22' AND DATE '2024-06-22' But i need to make the user select the required dates

Hoping some one can help, when I run the following code in PL/SQL developer it runs without an issue - however when I put the same code into an IAL no records are created. Why would that be please ? With Rowsnum As (Select to_char(dt,'dd/mm/yyyy') dt, row_number() Over( Order by dt) rnFrom ( SELECT ifsapp.cd_user_util_api.get_previous_period_end_date(sysdate) -366+ level dt from dual connect by level <= ifsapp.cd_user_util_api.get_previous_period_end_date(sysdate) - (ifsapp.cd_user_util_api.get_previous_period_end_date(sysdate)-366)) rws where to_char ( dt, 'fmday', 'nls_date_language = English' ) = 'monday'), RqdParts As (select part_no, ifsapp.Inventory_Part_API.Get_Description(CONTRACT,PART_NO) part_description, ContractFROM ifsapp.Inventory_Partwhere contract Not In ('CPH','CTM','VMS','CGP') --and part_no In ('WMPI10067','500086536','WSBB10501','WMVA10007')and Nvl(Substr(ifsapp.Inventory_Part_API.Get_Accounting_Group(contract,part_no),1,2),'Y') Not In ('IS','PH')) select ip.part_no

I just went through a successful upgrade from IEE to 23r2 deployed On Prem I have the provided IFS_INVENTORY, IFS_SALES, IFS_CRM, and IFS_PRODUCTION_PERFORMANCE models deployed for Data Mart and scheduled. I scheduled my Data Mart Refresh Category, Data Load, and Model Processing in a db task chain, these execute successfully, and I see my logs in both data and process runs. For some reason I don't see any data past the day I did the initial data load in SQL Server, the data is fresh in the MVT and BI tables. Can someone assist with this, if so, please let me know if more information is needed from me?

Hello, (Also created in Framework and Experience)I'm struggling with making my report work to use a dynamic search filter under Pivot for part_no. Does anyone have experience with this? Note, I don't use pivot in SQL very often and tried different approaches. I tried creating a subquery for shop_ord without success. I've also tried using regex: part_no IN (SELECT trim(regexp_substr('&part_no','[^;]+', 1, level)) AS q FROM dualCONNECT BY regexp_substr('&part_no', '[^;]+', 1, level) IS NOT NULL ) I also tried to use query flags without any success. So, I'm a bit stuck and unsure whether this can be done. Does anyone have experience with this? My SQL: WITH weeks AS ( SELECT TO_CHAR(TRUNC(SYSDATE, 'D') + (8 - TO_CHAR(SYSDATE, 'D')), 'IW') + (LEVEL - 1) AS week_number FROM DUAL CONNECT BY LEVEL <= 21),data AS ( SELECT TO_CHAR(TRUNC(s.REVISED_DUE_DATE, 'IW'), 'IW') AS week_number, s.PART_NO, SUM(NVL(s.REMAINING_NET_SUPPLY_QTY, 0)) AS total_qty FROM SHOP_ORD s WHERE s.STATE IN ('Planned', 'Re

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?

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/

Hi, When I'm trying to login into the Business Reporter using a super user username/password, it doesn't give any login error neither successfully load the reporter having closed the login dialog. When I choose the azure AD login option it says im already login. It seems something wrong with handling authentication code in the BR login dialog when even authentication happens successfully. Not loading after manually closing the login dialog too. Any workaround for this? This is IFS Cloud 24R1 Thanks! /Methshika

When logged into the Windows 2019 Jump server with a user with administrator rights, encountered an issue while attempting to initiate the IFS Excel Add-in. Upon starting Microsoft Excel and clicking on the IFS Excel Add-in icon, the Add-in launches successfully. However, when attempting to log in, encountered the following error: Web browsers are up-to-date and not working for both edge and chrome, versions installed on this jump server, Also installed WebView2, Would appreciate your insights on what could be the root cause of this issue

Hi all! We get the following error when trying to open and RDL in the latest version of Report Designer: We also have an older version installed and if we open the RDL in that version it works just fine. Any idea what the issue might be? Best regards

I have noticed a significant difference in the way Lobby Datasource page is loaded. Every refresh it retrieves all the available queries in the sudo-selector, and I usually end up waiting a full minutes before the page will respond. Has anyone else experienced this behavior? Is there any solution?

my main question is, Does the ifs application have a data warehouse service?

I am trying to setup my Analysis Models to populate to an on-premises server. The instructions are telling me : To achieve this scenario, where SQL Server needs to be accessed using the same IP address/FQDN both externally and internally, you can set up Split DNS or a Hosts file entry on the server running the SQL Server instance. I have tried to edit the host file by adding the external/public IP address as follows. Internal IP Exeternal IP or FRQN/Server Name 172.xx.xx.67 rs-IFS-biServer.domain.com 172.xx.xx.67 rs-IFS-biServer 172.xx.xx.67 170.xx.xx.245 Am I doing this right or do I have it backwards?

Within workflow I am trying to get the total number of records returned into the record set so. Can anyone advise a way to do achieve this?

Hi, Does anyone know a way to see the information sources used in Business Analytics/Business Reporter reports. Essentially trying to work out which of our QFACTs are not being used. Thanks