Calculated Measure that with no aggregation or dimension slicing

Question

Hi,

I have a cube with two dimensions, case and time and a single meaure

the requirement that I have is to provide time and case on Columns with Measures on Rows in the Form or a bar chart. My client would also like to compare the value of of each member of case with the average of all members case.

Is there a way to create a calculated member that will not aggregate or be sliced by the case dimension, so that the value of the average will always be the same for each member of the case dimension.

I am sure there is a simple way to do this, but I cannot find it.

Thanks,

Rich 

 

Answer 1

you can use the All member of the case dimension so that a calculated member is not affected by the case slicer on the axis

Example : SUM( Case.Case.[All], measure) versus SUM(Case.Case.currentmember, measure)

---

vinu

Answer 2

Actually it is better to use the Root() function instead of a reference to the all member.

eg. (Root([Case]), Measure)

If your dimension is simple then it may not make a difference, but specially if you have attribute relationship more than one level deep then the all member from one hierarchy can be filtered by a member in a related hierarchy in the same dimension.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers