Skip to Content
avatar image
Former Member

dynamic grouping in webi

Refer the below image, I want to create a webi report in which the sales revenue should display for each of the values I select for lines through query filter and the values which i dont select should show in a new row as others and the remaining total of sales revenue should display.

I am currently learning SAP BO for starting a new career and your answers to my queries will be of great help.

Thanks

capture.png (24.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 03, 2017 at 11:15 AM

    Follow these steps.

    Create two webi queries.

    First query with prompt filer on "Lines" object with equal to operator.

    Second query with prompt filer on "Lines" object with NOT equal to operator.

    Report level merge Lines object and create V Sales variable=[Query 1].[Sales revenue]+[Query 1 (1)].[Sales revenue]

    Create V Lines variable=If([Lines]=UserResponse("Enter values for Lines:")) Then [Query 1].[Lines] Else "Others"

    Drag V Lines & V Sales variables to get the results.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 04, 2017 at 08:02 PM

    Thanks for your answer.

    This is working with equal operator and for only one selected prompt value.

    My question was If we select list of values i.e. by using inlist operator than how to achieve dynamic result.

    Regards

    Aijaz

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2017 at 02:22 PM

    Hi Aijaz ,

    Add 2 queries one with all dimensions and measures , and 2nd query with only measure (no dimensions required) which you need to display "OTHER" value and keep the filter on dimension operator "not inlist" and operand as "Result from other query "

    first query should get filtered values and second query should get value for other members .

    as other values is an aggregated value , you can just insert a row in table footer and display the value .

    Thank you

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded