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