In excel I make an Analysis Services connection to a data cube and create pivot tables, charts, and whatnot. I would like to be able to show a user how current this data is by showing them when the last cube processing time occurred. Making an analysis services connection to the cube in SQL Server Management Studio (SSMS), I can right click on the cube and see the property of the last cube processing time exists. I can also create an MDX query as follows to return the last process time:. I would like to be able to query for and show this time in Excel whether it is via VBA code, or some other method. Does someone have a good suggestion on how to do this?
SELECT LAST_DATA_UPDATE FROM $system.mdschema_cubes