In SQL 2000 Analysis Service, Is it possible to create a dynamic MTD, LMTD,
YTD LYTD dimension in the cubes?

As it is the most common information that the user is looking for, I would
like to build a time dimension with MTD, LMTD, YTD and LYTD for the user to
drag and drop.

You don't need a separate dimension for this, just some MDX to include
calculated members into the cube for these values, using the built-in
functions for YTD etc.

Books like "SQL Server Analysis Services Step-by-Step" by Reed Jacobson,
"Fast Track to MDX" by Mark Whitehorn, Robert Zare and Mosha Pasumansky or
"MDX Solutions " by George Spofford will help you with the syntax.

"Kam" <Kam@discussions.microsoft.com> schrieb im Newsbeitrag
news:B71ACCFA-5164-43C1-A305-AF3559221508@microsoft.com...
> In SQL 2000 Analysis Service, Is it possible to create a dynamic MTD,
> LMTD,
> YTD LYTD dimension in the cubes?
>
> As it is the most common information that the user is looking for, I would
> like to build a time dimension with MTD, LMTD, YTD and LYTD for the user
> to
> drag and drop.
>
>