Skip to Content
0

dynamic grouping in webi

Jan 03, 2017 at 09:32 AM

115

avatar image
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

capture.png (24.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Jan 03, 2017 at 11:15 AM
0

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.


untitled.png (22.7 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 04, 2017 at 08:02 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Sateesh Kumar Bukkisham Jan 05, 2017 at 02:22 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded