Post reply

Description not available in DMV

  • July 23, 2015 at 8:51 am

    #398792

    Hi,

    I'm using the below mentioned 2 queries as MDX against my cube to get Description of attributes in Dimensions and Measures. But the "Description" column is displayed as empty. When I import the cube and open it in SQL Server Data tools, few attributes are having description. Please suggest if I'm missing something.

    SELECT [CATALOG_NAME] as [DATABASE],

    CUBE_NAME AS [CUBE],DIMENSION_NAME AS [DIMENSION],

    DIMENSION_CAPTION AS [DIMENSION CAPTION],

    [DESCRIPTION]

    FROM $system.MDSchema_Dimensions

    WHERE CUBE_NAME ='Model'

    --AND DIMENSION_CAPTION <> 'Measures'

    ORDER BY DIMENSION_CAPTION

    select * from

    $SYSTEM.MDSCHEMA_MEASURES

    where cube_name='Model'

    Cheers

    Jim

  • July 24, 2015 at 4:22 am

    #1814678

    Using Visual Studio, connect directly to your cube (it will say [Online] next to any tabs you have open). Have a look in the dimensions, are the descriptions there at the dimension (not attribute) level?

    I'm on LinkedIn

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

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