nem.ec

Programming Information Security Recipes Personal Code Snippets

SQL Server Analysis Services show last cube processed date

Display the last processed date for all cubes in SSAS

SELECT [CATALOG_NAME], CUBE_NAME, LAST_DATA_UPDATE
FROM $System.MDSCHEMA_CUBES
--WHERE LEFT([CUBE_NAME],1) <>'$'
ORDER BY last_data_update DESC

Dan Nemec
dan[]nem.ec

Github

Twitter