Hi,

I'm experiencing a strange problem after using the time intelligence wizard.
My YTD calculations seem to work correctly but I have difficulties querying
the member [Current Time] of the new created [Time].[Time Calculations]
hierarchy.

Lets compare these two queries:

SELECT
{[Time].[Time Calculations].&[Current Time]} ON Columns,
{[Measures].[Sales]} ON Rows
FROM SFE
WHERE ([Time].[Quarter].[Q1/2005])

and

SELECT
{[Time].[Time Calculations].&[Current Time]}
*
{[Time].[Quarter].[Q1/2005]} ON Columns,
{[Measures].[Sales]} ON Rows
FROM SFE

Please correct me if I'm wrong, but logically there should be no difference
between these two statements.
So I would expect that both statements return the sales of the 1st Quarter
2005. The second statement works as expected, but the first statement
returns the sum for the whole year 2005.

I've already cleared the MDX script, but that didn't change anything. So
calculations are not the reason for this behavior. My [Time] dimension is
very simple. It just consists of quarters and years. The key attribute is
quarters.

Thanks in advance for any comments.

Andreas