Skip to main content
Question

Update of IFS Cubes

  • April 21, 2020
  • 2 replies
  • 214 views

bengab
Sidekick (Partner)
Forum|alt.badge.img+4

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+9

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+4
  • Author
  • Sidekick (Partner)
  • 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.