dynamic grouping in webi

[Former Member]

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

[sateesh_kumar1]

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

[Former Member]

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

[amitrathi239]

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.