Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Dimensions heirarchy Issue in SSAS mdx

Author  Topic 

Starting Member

7 Posts

Posted - 2011-07-22 : 03:21:16
Hi Guys,

When I fired below query,

with member [Dim Date].[CalendarYear] As
[Dim Date].[CalendarYear].[Calender Year],[Dim Date].[CalendarYear].&[2005]
Select [Dim Date].[CalendarYear] on Columns,
{[Dim Account].[Account Type].&[Assets], [Dim Account].[Account Type].&[Revenue]} on rows
from InternetSales
Where [Measures].[Order Quantity]

I got an error "The 'Dim Date' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified." If somebody knows whats wrong with syntax Please let me know


Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-07-22 : 11:36:56
the error message is explicit. there are more than one hierarchy present in Dim Date hence ambiguity

SQL Server MVP

Go to Top of Page

- Advertisement -