Post reply

Converting @ISMBR into SSAS MDX query

  • July 9, 2015 at 6:36 am

    #148998

    Hi,

    How to convert Oracle @ISMBR function into SSAS MDX Query?.

    I tried like

    IIF(

    Count(

    Intersect(

    {MemberRange([New York],[New Hampshire])},

    {Market.CurrentMember}

    )

    ) = 1,

    <true-part>, <false-part>

    ) but it was not giving the correct output.

  • July 9, 2015 at 7:01 am

    #1811287

    saravanakumar.G (7/9/2015)

    Hi,

    How to convert Oracle @ISMBR function into SSAS MDX Query?.

    I tried like

    IIF(

    Count(

    Intersect(

    {MemberRange([New York],[New Hampshire])},

    {Market.CurrentMember}

    )

    ) = 1,

    <true-part>, <false-part>

    ) but it was not giving the correct output.

    There is no "MemberRange" function in SSAS MDX. You can use the ":" range operator instead: https://msdn.microsoft.com/en-gb/library/ms146001.aspx

    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