topic Cummulative sum through drill down i Cubes in SAS Web Report Studio

Cummulative sum through drill down i Cubes

Roth — Thu, 16 Feb 2012 12:06:53 GMT

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:

data test;

by year;

base=0;

base +1 (or base plus cost or sales);

run;

Is that possible i a OLAP Cube, and what about drill up/down

Cummulative sum through drill down i Cubes

jcbell — Fri, 09 Mar 2012 12:05:31 GMT

What viewer are you using? Most of the SAS OLAP viewers let you specify a total based upon all members or the members currently showing in the drill-down.

-John

Re: Cummulative sum through drill down i Cubes

Roth — Mon, 16 Apr 2012 08:45:50 GMT

Not quite what i meant.

ex.

data test;

Var 1 var 2

2 2

4 6

3 9

8 17

2 19

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.

Re: Cummulative sum through drill down i Cubes

shivas — Mon, 16 Apr 2012 09:46:44 GMT

Try this...Hope it helps

(SUM(PeriodsToDate([time].[All time].level),[MEASURES].[no_of_empSUM]));

Thanks,

Shiva