Formula error in a not leaf level -
08-24-2004
, 08:12 AM
I have a dimension Prod (Star Schema struture) that has the struture
bellow:
Total Prod
Prod A
Prod B
and I have another dimension, Schedule, wich is flat. My fact table
has the values:
Prod A Prod B
Schedule X 100
Schedule Y 10
Schedule Z
I created a Custom Member formula in Schedule Z that calcs X/Y for all
levels of Prod dimension, I mean, it's just X/Y, so when I slice the
cube in Total Prod member, the value of Z should be 10, but I've got
NULL, as in the example bellow.
Total Prod
Schedule X 100
Schedule Y 10
Schedule Z
It seems like the formula is working in the leaf level, because If I
change it to X+Y, I get the correct value, but it's strange because if
I put a 1 hardcoded in the formula, I get 1 in Total Prod instead of 2
wich is the value that would be returned if the formula was in the
leaf level.
My Prod dimension has the Unary Operator "+" in members A and B, I
don't have any other formula that use Schedule Z, I've also tried to
use a Cell Calculated formula, but the same strange behaviour occurs
with that. |