I have an SSIS package which process all object in my SSAS database. After a successful run of the package, i check the Last processed date from the databases property page in SSMS and it blank (i did not process the database when i deployed). I can however,
browse the database, and all expected data is there.
Also, I tried running the following statement against my database:
SELECT [CATALOG_NAME], CUBE_NAME, LAST_DATA_UPDATE FROM $System.MDSCHEMA_CUBES
The Last_Data_Update returned is way off i.e. the last_data_update returned is 21/10/2010 4:44:01 AM
I processed the cube at 15:00.
Any assistance greatly appreciated.
View Complete Post