How to get cubes deployed in SQL analysis service

asked 2021-11-16T13:17:12.357+00:00
balanarasimha c 466 Reputation points

Hi Team,

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
992 questions
No comments
{count} votes

Accepted answer
  1. answered 2021-11-17T02:03:46.803+00:00
    CarrinWu-MSFT 6,786 Reputation points Microsoft Employee

    Hi @balanarasimha c ,

    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.

    No comments

0 additional answers

Sort by: Most helpful