locked
Simplify my MDX IIF RRS feed

  • Question

  • I'm needing to create a measure in MDX to pass to SSRS, here's what I'm trying... Can it be simplified?

    IIF (

    ([Ordering Lab Receipt Date].[YEAR - Fiscal Year].

    CURRENTMEMBER) IS

    ([Ordering Lab Receipt Date].[YEAR - Fiscal Year].

    level(0)),"|",

    (

    MemberToStr ([Ordering Lab Receipt Date].[YEAR - Fiscal Year].CURRENTMEMBER))

    )

    Friday, April 8, 2011 11:26 PM

Answers