02-16-2012 07:06 AM
I am looking for a calculated menber in a OLAP Cube, where I can obtain a cummulative sum even though I drill up or down.
In normal base SAS I wil do:
base +1 (or base plus cost or sales);
Is that possible i a OLAP Cube, and what about drill up/down
04-16-2012 04:45 AM
Not quite what i meant.
Var 1 var 2
Var 2 is the accumulated var 1
I want the OLAP to be able to calculate var 2. I can do that in a data step, but I don't know how to tell the cube to acumulate var 1 into var 2.