Infoprovider text in report

[Former Member]

Hi Experts,

I have a query running against a Multiprovider. Our users want to see which source the key figures are picked from and to achieve this I have added the InfoProvider InfoObject from the Data Package Dimension in the BEX Query designer. When I run the report only the key of the InfoProvider InfoObject is displayed in the report not the InfoProvider name (text).

On the Display tab on the Infoprovider InfoObject properties in the Bex Query designer it is not possible to choose text (only "key" or "no display").

As our users have no relationship with the Infoprovider key we need to display the text instead. Is there an easy way to do this?

By the way: When I look at the Characteristic Values of the InfoProvider InfoObject it is able to display both the key and text, but I have not managed to get this text into the report.

Please help,

[Former Member]

Hi,

Did you find a solution ? Or did you change the 0InfoProv infoObject ? Or did you create a virtual characteristic ?

Regards,

Dieu

[Former Member]

I was not able to change the 0INFOPROV object as I could not change the display setting under the Business Explorer tab, so no solution was found yet. If you have additional suggestions I would be happy to hear it.

Thanks

[former_member418141]

Hi

Open BEx Query Designer, select your object (click on it), goto properties, select display ... show as: text; longtext.

After doing, your provider will be shown with its description.

Greets

TOM

[Former Member]

Tom,

Why don't u check the solution you propose ?

There is NO text available !!!

[Former Member]

Hi Odd,

Though not really sure with this idea but I guess the text can be displayed by creating a Customer Exit variable on 0infoProv infoObject.

In the exit define the text for the infoCubes involved in your multiprovider.

Regards

Shalabh

[Former Member]

I do not understand how defining an exit variable would help ?!

[mike_howles4]

Probably a Virtual Characteristic would work also.

[Former Member]

I do agree with the idea of a virtual characteristic, but not with the exit variable !

[Former Member]

Oops !

I have made a blunder. I thought it as a text display on the header of the column.

Apologies

Regards

Shalabh

[Former Member]

Hi,

You cant view the description of the infocube in the query.

Regards

Gattu

[Former Member]

Hi,

If in the Business explorer tab, you have made the default to text and key you should be able to change it on the query level.