Wednesday, May 4, 2016

SQL Server Analysis Services–Last process time

Just a quick post so I don’t forget how to get the last time the cube was processed from SQL Server Analysis services.

Execute the following query from inside SQL Server Management Studio:

SELECT LAST_DATA_UPDATE FROM $system.mdschema_cubes

That’s it!

No comments: