sql server data warehouse: Time dimension: MTD, LMTD, YTD, LYTD. how to define? -- sql server data warehouse

Time dimension: MTD, LMTD, YTD, LYTD. how to define?

Kam
8/24/2006 12:41:02 AM

sql server data warehouse:

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.

Re: Time dimension: MTD, LMTD, YTD, LYTD. how to define?

Helmut Knappe
9/8/2006 12:00:00 AM

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...
[quoted text, click to view]