Post reply

SSAS MDX

  • November 16, 2017 at 5:09 am

    #341380

    Hi,
    I am really getting confused with ALLMEMBERS and Members in MDX. Though i have seen examples on the internet nothing is giving me clarity. Can someone please help.

  • November 16, 2017 at 5:47 am

    #1968334

    susmitha117 - Thursday, November 16, 2017 5:09 AM

    Hi,
    I am really getting confused with ALLMEMBERS and Members in MDX. Though i have seen examples on the internet nothing is giving me clarity. Can someone please help.

    The key difference is that ALLMEMBERS returns calculated members whereas MEMBERS does not. Here's an example using Adventure Works:
    WITH MEMBER [Product].[Product].[ZZZZZZ]
    AS
    STRTOMEMBER("[Product].[Product].[ZZZZZZ]")

    SELECT
    [Measures].[Internet Sales Amount] ON 0,

    [Product].[Product].MEMBERS ON 1

    FROM
    [Adventure Works]

    In the above you won't see your calculated member but if you run the below you will:
    WITH MEMBER [Product].[Product].[ZZZZZZ]
    AS
    STRTOMEMBER("[Product].[Product].[ZZZZZZ]")

    SELECT
    [Measures].[Internet Sales Amount] ON 0,

    [Product].[Product].ALLMEMBERS ON 1

    FROM
    [Adventure Works]

    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