Skip to Content
0

Running Sum Filter issue

Feb 16, 2017 at 07:20 PM

76

avatar image

Hi Everyone,

I am trying to create a RunningSum for the [Number of Users] in particular table. XIR3, Webi, SQL Server DB As an example, lets say the report w/o filters would look something like this:

Month Jan-09 Feb-09 Mar-09 Apr-09 May-09
# Users 2 1 2 4 1
RunningSum 2 3 5 9 10

The catch is I need to show the overall running sum but allow users to prompt for a Date Range (say [Date] between 3/1/09 and 5/31/09). The report should display:

Month Mar-09 Apr-09 May-09

# Users 2 4 1

RunningSum 5 9 10

AND NOT!! (look at difference in the running sums):

Month Mar-09 Apr-09 May-09
# Users 2 4 1
RunningSum 2 6 7

Make sense? I've tried all sorts of multiple queries, sub queries, block filters, variables, NoFilter() etc just cannot find the right combination. Please let me know how I can clarify.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sree Nair Feb 20, 2017 at 06:56 AM
0

No one on this ???

Thought this issue should be a common one. How do people calculate inventory or working capital via Cumulative KeyFigures in BW but use them in BO WEBI reports.

If anyone has faced this kind of issues before, kindly reply here.

Rgds, Sree

Share
10 |10000 characters needed characters left characters exceeded
Koen Hesters Feb 28, 2017 at 08:47 AM
0

HI,

if it is prompted, you dataset will be overall filtered,

if you use input controls upon the dataset, the no filter will work, because all the dataset is uploaded first.

if you really want a prompt, you should calculate it on universe level

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded