It’s a common requirement in Webi nowadays to have linking of tables in webi. So based on the selection of one dimension in one table the dimension of other table should get restricted to it. For example I am analyzing my Measures with respect to customer now based on the selection of the customer in the table my other table which is showing profit centers should get restricted to it.

Problem in webi right now is on Hierarchies we can’t do the element linking.

So we need to apply some tricks to make it happen. And here is the trick.

Step 1. Create one dimension variable at the report level for hierarchy on which we want to do the element linking let’s say this is customers.

Image 1.JPG

Step 2. Now based create two tables one for the customers and other for the profit centers.

Image2.png

As you can see element linking is disabled which is the reason I am writing this blog.

Image3.png

Step 3. Put the Dimension Variable Parallel to the table

Image4.png

Step 4. Sort the Dimension Variable based onto the hierarchy

Image5.png

Step 5. Hide the Hierarchy column and put table next to the customer table so that this should look like a column from the same table by using the relative alignment property

Image6.png

Which make it look like this

Image7.png

Step 6. Now we can do element linking on Customer column dimension

Image8.png

To report this post you need to login first.

2 Comments

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

  1. Vidya Goruganthu

    Hello,

    I didn’t get how this will solve the hierarchy problem. This work around would not allow drill down on Hierarchy?

    Dimension variable is still not updated by the selection made in Hierarchy. So this will not update the charts with data link.

    Am I missing something here?

    Thanks,

    Vidya

    (0) 

Leave a Reply