Skip to Content
Author's profile photo Former Member

Make your BEx selection descriptions more relevant for webi users

Hi All,

  As a good practice it is recommended to make use of existing variables while creating a BEx query. Variable descriptions are fixed at the time we define them for a characteristic. A report developer assigns a descripton more relevant to report user. If a variable with same properties is required in some other report intended for a user who is part of some other business unit, for example vendor/transporter/service provider all are same but have different calling category for different business units. In these cases you do not have much choices at Bex level, you have to create a different variable if you want a different description on selection screen.

  If you are using Webi as your reporting solution then you can make use of same variable for any number of requirements without changing its base description (defined at BEx level).

For example a user who is performing analysis on Freight data will call its vendor as transporter. So webi selection screen will show Vendor by default (as maintained in BEx query variable).


Now we can fix its description in universe as below:

1) Open the underlying universe in Designer. Goto filters and double click the filter for vendor

2) A new window will open. Go in the where section and chnge descriptions maintained after @Prompt

Before Change:


After Change:


Parse and export the universe.

3) Open your webi report and refresh, you will see your selections with new descriptions.


Hope it will be useful to all BW-BOBJ developers. So make use of what system already have rather than spending some time to create a replica.



Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.