Post reply

SSAS Tabular Row Count from SSMS

  • September 22, 2016 at 10:28 am

    #330444

    Is there a quick way to determine the number of rows in a Tabular table from SSMS? I'm wondering if there is something similar to when you right-click on a "regular" table and get the row count from Properties.

  • September 23, 2016 at 12:40 am

    #1902708

    imani_technology (9/22/2016)

    Is there a quick way to determine the number of rows in a Tabular table from SSMS? I'm wondering if there is something similar to when you right-click on a "regular" table and get the row count from Properties.

    Not in the way you can with a SQL table (right click etc.).

    But you can run this query against the SSAS instance:

    SELECT

    DISTINCT

    [CATALOG_NAME] as [Database],

    [CUBE_NAME],

    DIMENSION_CAPTION AS [Dimension],

    DIMENSION_CARDINALITY AS [Count]

    FROM $system.MDSchema_Dimensions

    WHERE DIMENSION_CAPTION <> 'Measures'

    ORDER BY CUBE_NAME

    I'm on LinkedIn

  • September 23, 2016 at 9:37 am

    #1902828

    This is excellent, thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply