Top/Bottom Level Ranking based on the Slider in SAP Business Objects Web Intelligence
Introduction:
This document will provide the overview on how to display Top\Bottom 10 Product based on the Slider Input control.
Scenario:
Need to show Top/Bottom 10 Product based on the Slider Input control. Have taken E fashion universe to explain this scenario.
Steps to be followed.
2. For displaying Top/Bottom rank of sales revenue based on the year we need to create two variables. One variable for displaying Top sales revenue based on the year and another variable for displaying Bottom sales revenue based on the year.
3. Create two Variables one for Top Level Ranking and another for Bottom Level Ranking for sales revenue based on the year
Top Level Ranking: with the below mentioned formula
=Rank([Sales revenue];Top;[Year]) ForEach([State])
This formula will give Top ranking of sales revenue based on the year for each state
Bottom Level Ranking: with the below mentioned formula
=Rank([Sales revenue];Bottom;[Year]) ForEach([State])
This formula will give Bottom ranking of sales revenue based on the year for each state
4. Duplicate the table with the objects year, state and sales revenue. So that now we will have two blocks with the same objects and data as below.
5. Now have included the variable which has been created as Top Rank on Sales Revenue in the block 1 and Bottom Rank on Sales Revenue in the block 2. Sales revenue are Top/Bottom ranked based on the year for each state.
6. In order to have a slider as a input control with the values Bottom and Top, Create a Dimension “Top/Bottom” object at the universe level which has following value “Bottom” and “Top”
7.Once an object with the value Bottom and Top are created at the universe level, now we need to create input control in order to display Block 2 if “Bottom” is selected and Blcok1 if “Top” is selected. Click on New input control, Select the variable which we created and click on Next.
8.Select “Combo Box” from the simple selection list and Click ok.
9. Now we need to create a slider input control in order to perform Ranking. Click on New input control and select the object “Top Rank on Sales Revenue”. Click Next
10. Select simple slider from the simple selection list and provide the min value, Max value, Increment value and Default value. Select “Less than or Equal To” under filter operators because whatever value I slides it’s should be less than or equals to. For eg if I slides to 5 then it will display the ranking less than or equals to 5.
11. So now we created 2 input controls one with slider and other with combo box and our report will be in the format below: Based on the slider value both the Block Bottom and Top Rank on Sales Revenue will be displayed. Now we should hide the Block which has Top Rank on Sales Revenue when Bottom has been selected in the input control and vice versa.
12. Right click on the Bottom Rank block and mention the Formula as displayed. So it will hide the Block 2 (Bottom Rank) when the input control value is not equals to “Bottom".
=ReportFilter([Top/Bottom]<>"Bottom")
13. Right click on the Top Rank block and mention the Formula as displayed. So it will hide the Block 1 (Top Rank) when the input control value is not equals to “Top”
=ReportFilter([Top/Bottom]<>"Top")
14. Right Click on the “Bottom Rank” Block and adjust the relative position to “Top Rank” Block. So that when the input control value is selected we will have a feel that same block is performing the action instead of 2 blocks.
So based on the Top / Bottom input control we can toggle between Top ranking and Bottom Ranking of sales revenue based on the year for each state, and by slider inputcontrol(N performance) we can toggle between top 1 to top N ranking according to the maximum value set in the slider control.
Introduction:
This document will provide the overview on how to display Top\Bottom 10 Product based on the Slider Input control.
Scenario:
Need to show Top/Bottom 10 Product based on the Slider Input control. Have taken E fashion universe to explain this scenario.
Steps to be followed.
- Here have taken Year, State and Sales Revenue objects in my Data provider. And my table looks like below:
2. For displaying Top/Bottom rank of sales revenue based on the year we need to create two variables. One variable for displaying Top sales revenue based on the year and another variable for displaying Bottom sales revenue based on the year.
3. Create two Variables one for Top Level Ranking and another for Bottom Level Ranking for sales revenue based on the year
Top Level Ranking: with the below mentioned formula
=Rank([Sales revenue];Top;[Year]) ForEach([State])
This formula will give Top ranking of sales revenue based on the year for each state
Bottom Level Ranking: with the below mentioned formula
=Rank([Sales revenue];Bottom;[Year]) ForEach([State])
This formula will give Bottom ranking of sales revenue based on the year for each state
4. Duplicate the table with the objects year, state and sales revenue. So that now we will have two blocks with the same objects and data as below.
5. Now have included the variable which has been created as Top Rank on Sales Revenue in the block 1 and Bottom Rank on Sales Revenue in the block 2. Sales revenue are Top/Bottom ranked based on the year for each state.
6. In order to have a slider as a input control with the values Bottom and Top, Create a Dimension “Top/Bottom” object at the universe level which has following value “Bottom” and “Top”
7.Once an object with the value Bottom and Top are created at the universe level, now we need to create input control in order to display Block 2 if “Bottom” is selected and Blcok1 if “Top” is selected. Click on New input control, Select the variable which we created and click on Next.
8.Select “Combo Box” from the simple selection list and Click ok.
9. Now we need to create a slider input control in order to perform Ranking. Click on New input control and select the object “Top Rank on Sales Revenue”. Click Next
10. Select simple slider from the simple selection list and provide the min value, Max value, Increment value and Default value. Select “Less than or Equal To” under filter operators because whatever value I slides it’s should be less than or equals to. For eg if I slides to 5 then it will display the ranking less than or equals to 5.
11. So now we created 2 input controls one with slider and other with combo box and our report will be in the format below: Based on the slider value both the Block Bottom and Top Rank on Sales Revenue will be displayed. Now we should hide the Block which has Top Rank on Sales Revenue when Bottom has been selected in the input control and vice versa.
12. Right click on the Bottom Rank block and mention the Formula as displayed. So it will hide the Block 2 (Bottom Rank) when the input control value is not equals to “Bottom".=ReportFilter([Top/Bottom]<>"Bottom")
13. Right click on the Top Rank block and mention the Formula as displayed. So it will hide the Block 1 (Top Rank) when the input control value is not equals to “Top”
=ReportFilter([Top/Bottom]<>"Top")
14. Right Click on the “Bottom Rank” Block and adjust the relative position to “Top Rank” Block. So that when the input control value is selected we will have a feel that same block is performing the action instead of 2 blocks.
So based on the Top / Bottom input control we can toggle between Top ranking and Bottom Ranking of sales revenue based on the year for each state, and by slider inputcontrol(N performance) we can toggle between top 1 to top N ranking according to the maximum value set in the slider control.
- SAP Managed Tags:
