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
jzouaoui
Sidekick (Customer)
jzouaouiSidekick (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Ifs_sales cube

Hello, in the fact_customer_order_line_bi . I cannot see the correct amount if I have a credit that was made at the order level following an RMA. I can just see the amounts on the order line side and not on the invoiced line side and that creates an imbalance at the sales level.Exemple : Customer Order line  Side :fact_customer_order_line_bi : in power bi  fact_customer_order_lineCustomer invoiced Line side :  The  question : is there a way to resolve this issue and get the customer order line amount correctly

250
jzouaoui
Sidekick (Customer)
T
Sidekick (Partner)
TopDeepaWSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Can not saving/publish Business reports in IFS Cloud

Hi,I’m trying to save and publish a report to the IFS Cloud environment, but getting the below error. Kindly help me to resolve this. Error when saving the report in ifs cloudRegards,Deepal.

602
ashen_malaka_ranasinghe
Hero (Employee)
S
Hero (Customer)
SHAUN_KERSLAKEHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Reporting and Data Warehouse

Afternoon,We are in the midst of upgrading to IFS Cloud 23R2 from Apps 10, and in parallel the business are reviewing our BI strategy. Currently we use IFS Lobbies, Quick Reports and Business Reporter within IFS, and externally use tools such as PowerBI and Qlik. All our reporting is based on the production IFS Oracle database through ODBC connections. We plan on using PowerBI as the primary tool for management reporting, whilst continuing to use Quick reports and Lobbies for operational reporting within IFS.We are therefore considering options for data warehouse solutions such as Microsoft Fabric and PowerBI. We are looking for information on what other IFS customer's are using for their BI strategy and data warehousing solution, along with some pros and cons. Thanks in advance

2407
T
Sidekick (Customer)
R
Do Gooder (Customer)
RICARD MatthieuDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
SOD : Segregation of Duties in IFS Cloud

Hello, I’m working on IFS CLOUD (23.1.15) and i haven’t found the screen “SOD report” on it. If i see IFS V9, i obtain it, as you can see in attachment. Have you find a solution to execute this report on CLOUD, please ? Thanks a lot for yours returns and bests regards. Matthieu RICARDFIGEAC AERO 

503
PieterBroere
Sidekick (Partner)
V
Sidekick (Partner)
ViitatiSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Business Reporter - The website’s security certificate is not secure.

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 least twice.​​​​​​​Certificate are stored on “Trusted Root Certification Authorities” -folder. I also stored them to different locations too, but did not make any difference. This environmental is working on 24R1 SU1.

1486
V
Sidekick (Partner)
G
Do Gooder (Customer)
GulcanDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Issue with Saving Business Report as PDF

After generating the Business Report, I tried saving it as a PDF using the 'Save As' option from BR options, but the option is inactive. What could be the reason?  

271
T
Hero (Partner)
J
Hero (Customer)
JannetteCHero (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Creating a print job via plsql

I have the following code to produce the print record in the 'ACTIVE_SEP_WO_PRINT_REP' table.  DECLARE  printer_id_ varchar2(250);  print_job_attr_ varchar2(200);  report_attr_ varchar2(2000);  parameter_attr_ varchar2(2000);  print_job_id_ number;  printer_id_list_ varchar2(32000);  wo_no_ NUMBER := 303826;  result_key_ NUMBER ;      begin  printer_id_ := ifsapp.printer_connection_api.get_default_printer(ifsapp.fnd_session_api.get_fnd_user, 'ACTIVE_SEP_WO_PRINT_REP');  ifsapp.client_sys.clear_attr(print_job_attr_);  ifsapp.client_sys.add_to_attr('PRINTER_ID', printer_id_, print_job_attr_);  ifsapp.print_job_api.new(print_job_id_, print_job_attr_);     ifsapp.client_sys.clear_attr(report_attr_);  ifsapp.client_sys.add_to_attr('REPORT_ID', 'ACTIVE_SEP_WO_PRINT_REP', report_attr_);  ifsapp.client_sys.add_to_attr('LAYOUT_NAME', 'Delivery Collection WorkOrder.rpt', report_attr_);   ifsapp.client_sys.clear_attr(parameter_attr_);  ifsapp.client_sys.add_to_attr('WO_NO', wo_no_, parameter_attr

610
J
Hero (Customer)
H
Do Gooder (Partner)
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?

1246
S
Hero (Employee)
CGMRUNAL
Sidekick (Partner)
CGMRUNALSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Error in quick expense reporter configuration

Machine learning service is not accessible. Please ensure that the Machine Learning Service is enabled before turning this option on. What to do , when like this error is coming in Quick expense reporter configuration.

2097
Sahan Wijerama
Do Gooder (Employee)
R
Do Gooder (Customer)
RRYSRICHARDSDo Gooder (Customer)
asked in Insights (Business Reporter and Analysis Models, EOI)
Resource Forecast Information Source - Unable to Find

I am struggling to find what information source that would contain project resource forecasts. It does not show up in the Project Tabular Model (https://docs.ifs.com/ifsclouddocs/24r1/). I also cannot seem to find a entry in the information sources. The only reference I can see in the data mart sources are PROJECT_FCST_CONN_RFC_MV and PROJECT_FCST_CONN_CCO_MV Is this something I would have to build with custom queries or am I missing something? Note, the application table I am referencing is PROJECT_RESOURCE_FCST_TAB, PROJECT_RESOURCE_FSCT_ITEM_TAB, PROJECT_RESOURCE_FSCT_ELEM_TAB I am just trying to find the appropriate data mart source that would contain data from the IFSAPP tables. 

371
P
Do Gooder (Partner)
E
Sidekick (Partner)
EntUviniGSidekick (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Data Load Issue with DIM_ORGANIZATION_CODE

Hi ,We crated Data load run definition for IFS_EMPLOYEE_ANALYSIS Tabular model and getting below error.SSIS LOGWe 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

402
E
Sidekick (Partner)
N
Do Gooder (Partner)
NisansalaDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Adding a command to open a BR report in Cloud

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

511
S
Hero (Employee)
M
Do Gooder (Partner)
MangalaDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Is it possible to export IFS Business Reporter reports as .ins files?

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?    

781
M
Sidekick (Customer)
Asela Munasinghe
Superhero (Customer)
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

3359
Abdul
Superhero (Partner)
A
Do Gooder (Partner)
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

1204
AshenR
Hero (Partner)
A
Do Gooder (Partner)
AwijeDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
Restrict LOV on BR

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

241
ChanakaEA
Do Gooder (Partner)
T
Sidekick (Partner)
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. 

1284
ChanakaEA
Do Gooder (Partner)
Furkan Zengin
Ultimate Hero (Partner)
Furkan ZenginUltimate Hero (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

915
Furkan Zengin
Ultimate Hero (Partner)
M
Do Gooder (Partner)
m.dutkiewiczDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Businness Reporter - permissions for sources

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

1311
ChanakaEA
Do Gooder (Partner)
R
Do Gooder (Partner)
RudolphVDo Gooder (Partner)
asked in Insights (Business Reporter and Analysis Models, EOI)
IFS Business Reporter - Remove Old copies of a report

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?

1002
ChanakaEA
Do Gooder (Partner)
J
Hero (Customer)
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

573
ChanakaEA
Do Gooder (Partner)
F
Do Gooder (Customer)
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

664
F
Do Gooder (Customer)
J
Hero (Customer)
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

393
S
Hero (Employee)
PhillBronson
Hero (Customer)
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?

19511
S
Hero (Employee)
C
Do Gooder (Customer)
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

240
C
Do Gooder (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