Hi,
PBCS, I have a sparse dimension scenario.
I create a member with dynamic calc, formula; @Var(Budget,Actual); - I had originally tried Actual - Budget; - but moved to var when I saw that it took into account whether the account was expense or revenue.
Its parent is a label.
It validates and deploys fine.
It does nothing, all I get is #Missing - note the result was the same with Actual - Budget;
I try to change its 2 pass property, but this errors as its parent is not two pass. I cannot change a label's 2 pass property.
Any ideas please?
-edit; -
I have tried; -
adding a simple in case it was because it was one parent to one child based problem - no joy
checked my accounts are flagged as expense or revenue - they are
edit - added notes on original basis of calculation with same result in ASO cube