Dimensions heirarchy Issue in SSAS mdx

Please start any new threads on our new site at https://forums.sqlteam.com. 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

bhushan.juare
Starting Member

7 Posts

Posted - 2011-07-22 : 03:21:16

Hi Guys,

When I fired below query,

with member [Dim Date].[CalendarYear] As
Aggregate(
PeriodsToDate(
[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

Thanks..

visakh16
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
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources