Infoprovider text in report
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.