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.
Step 2. Now based create two tables one for the customers and other for the profit centers.
As you can see element linking is disabled which is the reason I am writing this blog.
Step 3. Put the Dimension Variable Parallel to the table
Step 4. Sort the Dimension Variable based onto the hierarchy
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
Which make it look like this
Step 6. Now we can do element linking on Customer column dimension