Calculated Member Issue

Dear all,

My project running on AS2005 contains a dimension with 5 values in its table.

The fact table contains values for 4 of the values of the dimensions (the last one has not value yet).

When I browse the cube, if I display a calculated member (a sum) as measure and the dimension, I can see the measures for the 4 values of the dimension (the last value is not displayed).

But if I display a calculed member (done with "CALCULATIONS and which correspond to Measure.A/Measure.B), I see the measures for the 5 values of the dimension (the last value is displayed even if it has no value in the fact table). The fifth one is blank.

How can I avoid this ?

Thanks in advance for your support.

Juan

Hi Juan,

I'm assuming that you meant to say: "..if I display a sum measure and the dimension, I can see the measures for the 4 values of the dimension..".

So, if your issue occurs only with the calculated measure, not with measure group measures, you could try specifying Non Empty Behavior, like:

Create Member CurrentCube.[Measures].[RatioAB]

As [Measures].A /[Measures].B,

Non_Empty_Behavior = [Measures].B;