Traditional web-based reporting with SAS BI tools

Cummulative sum through drill down i Cubes

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

Cummulative sum through drill down i Cubes

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


Accepted Solutions
Solution
‎04-16-2012 05:46 AM
Super Contributor
Posts: 349

Re: Cummulative sum through drill down i Cubes

Hi

Try this...Hope it helps

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



Thanks,

Shiva

ShivaCube output.png

View solution in original post


All Replies
Contributor
Posts: 42

Cummulative sum through drill down i Cubes

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

Occasional Contributor
Posts: 6

Re: Cummulative sum through drill down i Cubes

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.

Solution
‎04-16-2012 05:46 AM
Super Contributor
Posts: 349

Re: Cummulative sum through drill down i Cubes

Hi

Try this...Hope it helps

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



Thanks,

Shiva

ShivaCube output.png

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 681 views
  • 1 like
  • 3 in conversation