Running Sum Filter issue

[Former Member]

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.

[kohesco]

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

[Former Member]

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