Home Forums Data Warehousing Analysis Services MDX to Get Customer Status in given date range RE: MDX to Get Customer Status in given date range

  • October 3, 2013 at 2:52 am

    #1655451

    SELECT {<<some measures>>} ON 0,

    [Customer Dimension].[Customer Status].[Customer Status] on 1

    FROM <<your_cube>>

    WHERE (NULL:[Dim Date].[Date].&[26062013])

    This code will effectively give you the customer status from Start of Date in the dimension till 26th June 2013

    Raunak J