I am trying to create the "Periodicity" dimension described in "MDX Solutions". I tried to create a new dimension in Cube Editor and Dimension Editor. The Wizard wants me to select a table from the database, but there is no table for "Periodicity" dimension. How do I create this dimension in Analysis Manager?
Thank you.

You need to create a dimension table - see examples below:

- Tom Chester's web-site has this sample database, which creates a
calculation dimension with a YTD member:

http://www.tomchester.net/articlesdo...dimension.html


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

http://support.microsoft.com/default...;EN-US;q304118
...

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

http://groups.google.com/groups?q=sp...on&hl=en&lr=&i
e=UTF-8&oe=UTF-8&selm=3D66285F.F69BE1E5%40dsslab.com&rnum=1
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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!