How to get cubes deployed in SQL analysis service

Question

Hi Team,

Have multiple cubes deployed in SSAS, i want to get list of cubes deployed in SQL with last process date

Answer 1

Hi @Bala Narasimha Challa ,

Thanks for your posting.

You could get the latest update date from MDSCHEMA_CUBES rowset, please try below script:

SELECT CUBE_NAME AS [Cube/Perpective], LAST_DATA_UPDATE,* FROM $System.MDSCHEMA_CUBES  
WHERE LEFT(CUBE_NAME, 1) <> '$'   
ORDER BY LAST_DATA_UPDATE DESC  
  
-------  
  
SELECT CUBE_NAME AS [Dimensions], LAST_DATA_UPDATE,* FROM $System.MDSCHEMA_CUBES  
WHERE LEFT(CUBE_NAME, 1) = '$'   
ORDER BY LAST_DATA_UPDATE DESC  

Please note that the date and time provided are in UTC, you have to perform conversion to local time. Any process of a table or also a single partition of a table will reflect in an updated LAST_DATA_UPDATE. For more information, please refer to this thread and 3.1.4.2.2.1.3.5.1 Columns.

Best regards,
Carrin

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.