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.
Update of IFS Cubes
Userlevel 2
+3
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
Userlevel 2
+3
Hi, I forgot to update this case. We discovered that som PROD cube was pointing av TEST. Thats why the cube dont update.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.