When i drag a Query calculation for a dimensional source we are prompted to choose between "Calculated member", "Calculated measure, "set expression" & "Other expression". Along with it we need to choose a hierarchy. How and why do we need to choose a hierarchy?
You don't need to choose a hierarchy for all of these options. Where you do, you are simply defining the scope of the calculation.
Cheers!
MF.
When we say it defines scope does that mean that the calculation is limited to only that hierarchy, because i think it is single select. What happens to other hierarchies then