Calculated Dimension Member destoys date-hierarchy structure

Hi, I have a problem if I add a Calculated Dimension Member to a Date Hierarchy,

first I thought - I would set attribute relationship of my date-dimension not properly,

but then I tried to apply this to AW-DataBase.

Here's a script of creating Calculated Member in AW (Date.Calendar):

CREATE MEMBER CURRENTCUBE.[Date].[Calendar].[All Periods].[DateCalcMember_CopyOf2004]
AS [Date].[Calendar].[Calendar Year].&[2004],
VISIBLE = 1 ;

After adding it, try to expand the years-nodes in browser: you won't find any semesters behind,

except CY2001 - he got all semesters of other as childs.

It is possible to configure this behaviour somewhere or it is a bug of OWC 11 PivotTable that is used

in Cube Browser?

Thank you in advanced for your answers.

Regards, Mastroyani

Hi Mastroyani. Your problem definition is not 100% clear, so I made an assumption. The assumption is the problem definition which is, "after adding the calculated member and browsing the dimension in the cube browser the only member which shows the half-year members ([H1 CY 2002], [H2 CY 2002], etc.) is the [CY 2001] member." You can isolate where the problem lies by using another tool such as the SQL Server 2005 Manager to issue a separate MDX query outside onf the Cube Browser. Below is an MDX query using your same definition for [DateCalcMember_CopyOf2004]. You can see from the results that the member [CY 2004] shows it's own half-year children. Perhaps you are seeing an error with the cube browser?

Hope this helps - Paul Goldy

WITH MEMBER [Date].[Calendar].[All Periods].[DateCalcMember_CopyOf2004]
AS '[Date].[Calendar].[Calendar Year].&[2004]'

SELECT
{[Measures].[Internet Sales Amount]} ON COLUMNS
,{[Date].[Calendar].[Calendar Year].&[2004]
,[Date].[Calendar].[Calendar Year].&[2004].Children
,[Date].[Calendar].[All Periods].[DateCalcMember_CopyOf2004]} ON ROWS
FROM [Adventure Works]

===== Results

Internet Sales Amount
CY 2004 $9,770,899.74
H1 CY 2004 $9,720,059.11
H2 CY 2004 $50,840.63
DateCalcMember_CopyOf2004 $9,770,899.74

|||Hi, I have exactly the same problem. Have anybody figured out the problem?

thanks
Hank