Dimensional calculation

[dssd]

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?

[MFGF]

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.

[dssd]

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