Skip to Content

Web Intelligence is called the “interactive tool” of the BI Platform, so let us be interactive.

Using input controls helps us a lot achieving our target.  You can use them to filter your report data, but also to change the layout or change keyfigures/measures in the report.  In the folowing steps we will change the layout of our report.

This is our report: that we would like to have interactive.  Initially we show the graphs of our data, but we want to show the table as well.Capture.PNG

Step 1 – create a new variable, “View”: add the text: “Table Purchase Orders”.

Capture2.PNG

Step 2 – Create a new inut control based on the new variable, “View”.

Capture3.PNG

Step 3 – Customize your list of values of your input control.

Capture4.PNG

Step 4 – “Hide when …” your table/graphs, using a formula like …

Capture5.PNG

     – here you can go wild and change a lot, for instance my title and background cell’s will change as wel.

Step 5 – enjoy the view

Capture6.PNG

The “all values” will be my initial screen, the “table purchase orders”, will trigger my table in the report.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply