Skip to main content
Question

Update of IFS Cubes


bengab
Sidekick (Partner)
Forum|alt.badge.img+3
  • Sidekick (Partner)
  • 5 replies

Is there someone that knowns any problem with sql server and updating of the IFS cube. We use SQL server 2017 and IFS 10?
We find that the database is being updated by the scheduled jobs but the cubes aren’nt.

2 replies

Forum|alt.badge.img+8

Hi, 

Do you mean the cubes are empty even after ETL schedules are executed? Most common reason behind empty cubes is empty Dm_Fact_Reporting_Currency_Rate table. Please check if that table has data. Also make sure that you have done the lookup configurations properly. You may refer IFS technical documentation for this and I have added the path to find it. 

Best Regards,

Nisansala


bengab
Sidekick (Partner)
Forum|alt.badge.img+3
  • Author
  • Sidekick (Partner)
  • 5 replies
  • August 26, 2020

Hi, I forgot to update this case. We discovered that som PROD cube was pointing av TEST. Thats why the cube dont update.


Reply


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