Skip to Content
avatar image
Former Member

Running Sum Filter issue

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 20, 2017 at 06:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28, 2017 at 08:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded