Skip to Content
Author's profile photo Abhishek Jain

Adding Element Link on BW Bex Hierarchy Objects

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.


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


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice blog Abhisek.. welcome to blogging..

      Author's profile photo Former Member
      Former Member


      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?