Post reply

MDX: OR in the WHERE

  • February 24, 2009 at 5:32 am

    #206210

    i'm sure this is simple enough....

    how do i do an "OR" in the "WHERE" part of MDX

    something like

    WHERE

    [CCY].[CCY].&[GBP] AND ( [FromDate].[FromDate].&[2009-02-23T00:00:00] OR [StartDate].[Start Date].&[2009-02-23T00:00:00])

    sure it's just my brain being hard wired to SQL...

  • February 24, 2009 at 6:16 am

    #949280

    actually...i think i've got it

    WHERE

    CROSSJOIN

    (

    [CCY].[CCY].&[GBP]

    ,

    UNION

    (

    ([StartDate].[Start Date].[All],[FromDate].[FromDate].&[2009-02-23T00:00:00])

    ,

    ([StartDate].[Start Date].&[2009-02-23T00:00:00],[FromDate].[FromDate].[All])

    )

    )

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

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