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.

5 Comments

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

  1. vsenni senni

     

    Hi Koen Hesters,

    I am following your Post always

    I have a requirement to hide and show the report block based on the Element Link  unfortunately i promised to the user its achievable.

    I have 4 Table Block.

    Table 1 : Master table 1

    Table 2: Child Table of Master table 1

    Table 3: Master table 2

    Table 4: Child Table of Master table 3

    Requirements

    When the user Click Table1 then Table 2 should enable.

    When the user Click Table 3 then Table 2 Should Hide and Table 4 should enable .

    The above one I achieved it based on the below logic. I have written this logic in Table properties (Hide when the formula is true)

    Table 2 = If ((Pos(ReportFilterSummary();”Table 4″) = 0) ;”Hide” ; “Show”) =”Show”

    Table 4 = If ((Pos(ReportFilterSummary();”Table 4″) = 0) ;”Hide” ; “Show”) =”Hide”

    Now if the user Click Back to Table 1 then Table 2 should bring back and Table 4 should hide. But I couldn’t able to achieve this

    Can you please help me.

    (0) 
    1. Koen Hesters Post author

       

      Hi,

      flattery works, the element linking nonetheless.  If you want it to work when clicking only once, meaning click Table 1 show tale 2 click table 3 show table 4 and hide Table 2 it is doable by adding an OR in your hide-formula, but it stops here, when they click again no changes will/can be captured because there is no reset-formula available unless they reset the element link manually.

      That was the reason to build it via the input control

      grtz

      Koen

      (0) 

Leave a Reply