Skip to Content

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).

Prompt.png

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

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

Before Change:

Cond1.png

After Change:

Cond2.png

Parse and export the universe.

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

Newsel.png

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.

Regards:

Jitendra

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