SSAS: Dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified

You attempt to query a member of a dimension but get the error “Dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified”.

This can happen when you don’t properly qualify a measure or dimension e.g. you specify [MeasureName] instead of Measures.[MeasureName] or you attempt to refer to a dimension attribute via [Dimension].Currentmember instead of [Dimension].[Hierarchy].CurrentMember – Checking all of your Calculations is likely to reveal the culprit.

 

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s