Skip to main content
Solved

IFS OLAP Sales Cube Measures not populating

  • November 12, 2019
  • 3 replies
  • 350 views
chrisbrigg
Sidekick (Customer)
Forum|alt.badge.img+4

We have successfully deployed and populated the IFS Business Analysis Package OLAP cubes for IFS Apps 9 in a test environment. I found the Measures deployed within the Sales cube, which are based on the SUM aggregation, are not populating. However, I have confirmed there are Measures based on the SUM aggregation functioning correctly within the Manufacturing cube.

There is data within the Sales-related Data Mart SQL tables as well. I did try changing the data types on the SQL Data Mart table and in the Cube via Visual Studio, neither of which worked.

Has anyone else experience issues like this with the IFS OLAP cubes? Basically, there is data within the SQL tables but the Cube measures are not aggregating the SUM in the Sales OLAP cube.

 

 

 

 

Best answer by Nisansala Liyanage

I have seen some issue where cubes become empty due to empty Dm_Fact_Reporting_Currency_Rate table. Please check if that table has data. Also, make sure that you have setup all the configurations for lookups correctly according to https://wit.ifsworld.com/f1docs/apps9upd15/Foundation1/040_administration/255_business_intelligence/040_BI_Analysis_Package/300_BIAnapacConfigLookup.htm

View original
Did this topic help you find an answer to your question?

3 replies

N
Hero (Partner)
Forum|alt.badge.img+9

I have seen some issue where cubes become empty due to empty Dm_Fact_Reporting_Currency_Rate table. Please check if that table has data. Also, make sure that you have setup all the configurations for lookups correctly according to https://wit.ifsworld.com/f1docs/apps9upd15/Foundation1/040_administration/255_business_intelligence/040_BI_Analysis_Package/300_BIAnapacConfigLookup.htm

chrisbrigg
1 person likes this
  • chrisbrigg
    chrisbrigg
chrisbrigg
Sidekick (Customer)
Forum|alt.badge.img+4
  • chrisbrigg
  • Author
  • Sidekick (Customer)
  • 7 replies
  • November 13, 2019

Nisansala, thank you for your response. I checked the tables and DW_Fact_Reporting_Currency_Rate and DM_Fact_Reporting_Currency_Rate are empty. The IFSAppl_FACT_CURRENCY_RATES_BI_OPT table has data, however. I am looking into the .dtsx packages to see where the problem is occurring. Have you experienced this before?

chrisbrigg
Sidekick (Customer)
Forum|alt.badge.img+4
  • chrisbrigg
  • Author
  • Sidekick (Customer)
  • 7 replies
  • November 13, 2019

Nisansala’s response lead me to the correct solution, which was all related to Data Configuration within IFS application and the SSIS Configuration Tool. 

Specifically, some Data Mart Sources needed to be Activated and refreshed manually within IFS IEE after the initial installation. I also checked the settings for the SSIS Config Tool and noticed I had not correctly set up the Master Company within Reporting Currency Rate Type Lookup and Reporting Period Lookup.

I saved all changes and ran the ETL process again, which populated the Currency Rate tables and Sales cube successfully. Thank you again for your help!

 

KristenGastaldo
N
2 people like this
  • KristenGastaldo
    KristenGastaldo
  • N
    Nisansala Liyanage

Reply


Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings