Cubes Partially Processed
Since adding an additional management pack to my system which should enable tracking of comments in the DWH, my WorkItems cube is at a partially processed state in SCSM console.
This seems to be affecting the PowerBI auto-refresh I have going too.
Anyone ran into this?
Otherwise, there are many good blogs about re-running your DWMaintenance, MPSync, and ETL jobs in order before attempting to process again. If that does not work (as has been my experience more than once), you may not have enough RAM in your DW server. That is where I am currently sitting, with more than one cube. Others will process. I know this is my issue because I have fixed all other problems. All my MP's are synced to the DW (often an issue) and all my dimensions have been fixed since correcting that.
It is entirely possible that your experience is not the same as mine, but maybe this will get you pointed in the right direction. I know @Conner_Wood has some articles that have good advice in them, and would suggest blogs from Travis Wright and Mihai Sarbulescu as well.
Good luck. The DW can be very frustrating to troubleshoot, but it is usually worth the trouble.
Probably separate, but I can refresh manually using PowerBI desktop but not via PowerBI Gateway! Bizarre!
@John_Long please have a read through the following articles, it may save you time and even your sanity:
SCSM: Perfect the SSAS Cubes
SCSM Data Warehouse: Fact Groom Retention - Prevent Relationships Getting Marked As Deleted
Also, I included my management pack to archive comments in the SCSM Reviewer Portal as well as instructions ... I recommend you double check yours is archiving all the important comments for all the tickets.
Or view the Management Pack here: My.WorkItem.CommentLog.DataWarehouse.xml
You would need to seal using FastSeal.exe (download FastSeal.zip from SCSM Blog) then imported sealed MP into SCSM.
The Data Warehouse is a monster all its own, it doesn't surprise me it doesn't get along with other programs.