Webi tricks : Interactive selecting and viewing TOPn data

[wmarcy]

Hi everyone,

In this trick I will show you how to dynamically display data tables with differents ranks in Read mode without entering in Design mode.

Application : Web Intelligence 4.1 SP2

Use Case : I want to dynamically see on the same report, all my datas and add a ranking with different TOPn without editing the document in Read mode.

Create a report and add a table

Insert your first table with all data displayed.

Create your TOPn selection variable

In order to set up dynamic visibility, I'm going ti use an Input Control with a variable. This variable will allow user to choose the level of ranking of tables displayed on the report.

Create your TOPn Input Control

These steps show how to create your input control with custom values corresponding to the number of tables you want to display on your report. I've chosen a Radio button but you can choose other control. The important stemp is to configure custom values. There's no dependancy for this input control.

Create your TOPn tables and ranking

Now, you can duplicate your first table and change format to make difference between each rank value. To make it real, you can use relative position to ensure the relative position of tables whatever the data displayed.

Hide/Show table dynamically

All is ready to hide tables according to the selection of your input control previously created. Right clic on a table, go to "Format" and enable "Hide when following formula is true" for each table sucha as below :

For example, my table named "Table_TOP5" will be displayed only when my variable "TOP" will obtain value "TOP5" with my input control. Other case will hide my block.

Repeat this step for each block and you're done !

Conclusion

When opening my document, I can choose which kind of ranking I want to read and export to answer quickly to a business issue. I don't to ask someone to modify the document in order to change ranking values.

More Webi tricks on Webi Tricks Summary : http://scn.sap.com/docs/DOC-50171