CODEWITHSUNDEEP
sql-serverssascubessas-2008ssas-2008-r2
user1254579
user1254579

Reputation: 4009

ssas hierarchy member and hierarchy level members difference

The ssas dimension, Period consists of an hierarchy, [period calendar] and there are 2 levels [period year] and [period name].

There are members under [period name] (level members) and also, there are members under [members] folder. What are the differences between these two set of members? These two sets look the same.

enter image description here

Upvotes: 0

Views: 256

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31775

They are two ways of accessing the same members. Drag them onto an MDX query to see how they would be expressed in MDX.

Upvotes: 1

Related Questions