Creating Calculated Member based on NOW() RRS feed

  • Question

  • Hi,
    This is a newbie question but I've been messing with this issue for a while so I thought I'll just ask for some help. I am using SSAS 2005.
    My Date dimension members looks like this :

    [Date].[Year - Month].[Year].&[2007].&[Q3].&[7].&[07/11]

    I would like to create two calculated members. one that will represent the current day and one that will represent yesterday's date.

    I tried to do stuff like :

    [Date].[Year - Month].[Year].&[YEAR(NOW())].&[Q3].&[7].&[07/11]

    And it didn't even recognize the year. I didn't even get to the part when I try to calculate the quarter string.

    How do I do it ?
    How will I represent Q3 ?
    How do I use date functions to represent the day before, last 3 months etc ?

    Thank you !
    Monday, July 16, 2007 6:12 PM

All replies