I have come across YTD being used in Calculated Members. My users want
a YTD dimension where they can select FebYTD (for example) and see that
data. Can this be accomplished using Custom rollup in my time
dimension? Any help would be greatly appreciated.

Rob

http://groups-beta.google.com/group/...rver.olap/msg/
16519fcd135e1c93

http://groups.google.com/group*s?q=t...+pu*ri&hl=en&l
r=
&ie=UTF-8&group=microsoft.publ*ic.sqlserver.olap&selm=OB8u BCf*PEHA.1048%
40tk2msftngp13.phx.g*bl&rnum=3
..
- Tom Chester's web-site has this sample database, which creates a
calculation dimension with a YTD member:

http://www.tomchester.net/arti*clesd...imen*sion.html


- Here is a Microsoft support article, using Foodmart 2000 Sales cube:

http://support.microsoft.com/d*efaul...EN-US;q304*118

INF: How To Perform Time Series Calculations (Q304118)
..

- And here is a post from George Spofford, author of "MDX Solutions":

http://groups.google.com/group*s?q=s...sion*&hl=en&lr.
..

A time analysis utility dimension has no all level and 1 real member in
a dimension table named something
like "Current" with a key value like 0 or 1. You can create and process
the dimension as usual. Bring the
dimension into the cube, join it to the fact table on any column of the
fact table, and set the member
key in the cube the constant 0 or 1 (matching Current's key).

Add calculated members to the cube on this dimension:

CREATE MEMBER [Time Series].[YTD] AS
'Aggregate (
PeriodsToDate (
[Time].[Year],
[Time].CurrentMember
),
([Time Series].[Current])
)'

CREATE MEMBER [Time Series].[QTD] AS
'Aggregate (
PeriodsToDate (
[Time].[Quarter],
[Time].CurrentMember
),
([Time Series].[Current])
)'

A query for YTD sales at August 2002 is a query for the tuple
([Measures].[Sales], [Time Series].[YTD], [Time].[Aug 2002])

HTH

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanks for the quick response. I am going through some of these
examples.

Rob


Deepak Puri wrote: