Insights (Business Reporter and Analysis Models, EOI)

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

620 Topics
1,750 Replies

ChanakaEADo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Analysis Models - Power BI Sales Parts

Hi,According to the latest IFS GPL and 24R2 sales part list, there are only two Power BI-related sales parts available:Advanced Analytics - Self Managed Analysis Models - Self ManagedI would appreciate more information about the latest sales parts related to IFS Analysis Models (24R2). Could you please provide answers to the following questions?What sales part(s) are needed to use IFS Analysis Models - Power BI with a self-hosted BI infrastructure setup? What sales part(s) are required for using IFS Analysis Models - Power BI (data lake Gen2) and IFS Advanced Analytics? Is it possible to purchase Advanced Analytics - Self Managed without purchasing Analysis Models - Self Managed? Does this mean that iFrame integration is always available and not dependent on any sales part? Can we assume that IFS Analysis Models – Tabular is no longer available for purchase?Thank you.

140

1 day ago

Asela MunasingheSuperhero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Access Permission to a few users for a specific quick report

Hi allI 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

275

16 hours ago

Fentiger79Do Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Quick report SQL help

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 withAND 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

274

3 days ago

JannetteCHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

IAL issue

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'))sel

193

8 days ago

CordiusDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Report how to use dynamic filter in pivot1?

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 FRO

14 days ago

PhillBronsonHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Tabular Model : No data transferred after initial Data Load

I just went through a successful upgrade from IEE to 23r2 deployed On PremI 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?

8611

9 days ago

TopDeepaWSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Migrating IFS Business Reports from Apps 10 to IFS Cloud

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.

484

18 hours ago

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?

162

1 month ago

himasha.abeywickramaDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Tabular Models : Best practices

Hello,Is there a way to retain the following during an upgrade or prior to go-live?Tabular model deployments Created data load/process jobs Scheduled jobs Entity criteria for incremental loadingWhat are the best practices to follow during an upgrade or go-live process?Which information can be retained, and which ones need to be re-deployed?

404

1 month ago

JannetteCHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

QFACT views

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

193

22 hours ago

Furkan ZenginSuperhero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter Drill Down Not Navigating to IFS

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

425

21 hours ago

AnyDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Uninstall ClickOnce application

Hello community,I am trying to install BR for APPs10 through the MSI file, but the following error message is displayedI 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

332