|
Home > Archive > MS SQL Server OLAP > November 2005 > Relative Time
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hi,
As anybody figured out how to implement a Relative Time Dimension or
Hierarchy with AS 2005.
I'm trying to create a dimension that will hold something like this:
Year to date
Month to date
Rolling 12 months
Same month previous year
....
Thanks,
Eric
| |
| Mike White 2005-11-30, 8:24 pm |
| The business intelligence wizard does a fair job of creating these
measures... Look for the "Add Business Intelligence" button at the far left
of the cube designer. If you need to have something slightly different than
the wizard adds, you can modify the code on the Calculation tab.
Good luck! --Mike
"Aiwa" wrote:
> Hi,
>
> As anybody figured out how to implement a Relative Time Dimension or
> Hierarchy with AS 2005.
>
> I'm trying to create a dimension that will hold something like this:
> Year to date
> Month to date
> Rolling 12 months
> Same month previous year
> ...
>
> Thanks,
> Eric
>
|
|
|
|
|