Post reply

MDX for Today's date

  • June 13, 2011 at 6:10 am

    #251850

    All

    Can anyone help me with the syntax for Today's date? I need to add it as slice information for partition slice on a ROLAP partition.

    I assume it's something like

    [Date].[DateID].membervalue = now()

    but unsure. Any help greatly appreciated.

    Thanks.

  • June 13, 2011 at 11:33 pm

    #1338165

    You are on the right track with the NOW() function. However, you will need to format the string to match the member name. Not sure what the answer will be for you since I don't know what your member name actually looks like but it is likely to be something like

    "[Date].[DateID].[" & FORMAT (NOW() , "yyyymmdd") & "]"

  • June 14, 2011 at 12:06 am

    #1338180

    Perfect - thanks a lot. Thinking about this, I can set my ROLAP partition slice this way, but my "everything else" partition I guess needs slicing too.

    Can you use something like [date].[dateid].membervalue <> Now() etc

    for all dates other than today?

    JK

  • June 15, 2011 at 6:34 am

    #1338921

    Not sure of the context. However, have a look at either FILTER or EXCEPT. They should be able to do what you need.

Viewing 4 posts - 1 through 3 (of 3 total)

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