I have a shared time dimension of Year--> Quarter --> Month --> Date and
would like to have another shared time dimension containing "Relative" times
such as Today, Yesterday, YTD, Last Year YTD, ... I used calculated measures
in the cube using the MDX functions and they work, but it doesn't allow the
user to work with it like a dimension. For example being able to select the
"Relative" timeframe from a drop down, ...

Also, these calculated measures are not shared across all cubes in the
database.

Thank you very much.

H

you can create new data dimensio
example for previous yea
DatePart(year,"dbo"."Data"."Data"-365
or for mont
DatePart(month,"dbo"."Data"."Data"-365)

Thanks for responding, but what I am looking for is the ability to create a
dimension or something that acts like a dimension with Excel that would have
non-hierarchial members of Today, Yesterday, ... that could be used to
restrict the data similar to selecting a specific quarter in the normal Time
Dimension.

-- Gary

"Alex" <alex_priv (AT) interia (DOT) pl> wrote

Thank you very much. Here is another article that I found useful:
http://www.tomchester.net/articlesdo...dimension.html


"Brian Altmann" <anonymous (AT) discussions (DOT) microsoft.com> wrote