Skip to Content
0

WEBi List of values for Hierarchy prompt based on BW query

May 14 at 02:58 PM

49

avatar image

Hello,

We have a WEBi prompt which uses BW query , so basically BICS connection.

In the BW query we have the hierarchy input node variable.

In the WEBi prompt, when i switch on the key values to see the key value of the nodes, i always see the key value in this format : "Info object name/ Key Value". This happens for all the level except the last one where we only see the Key Value.

How can i switch off the Infoobject technical name from appearing in the key values? The business user gets confused seeing the technical names.

I have attached the screenshot to highlight the scenario. Our WEBi version is 4.2 SP 03

Thanks in advance,

A Singh

sdn-webi.png (3.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A May 14 at 05:45 PM
0

Hi,

That must be compounding char value of your attribute.

Have a restriction within BEx query.

Or if you think that is Info object Technical name, then you can set to show only Text of that Info object within BEx query but is that technical name of an Attribute or Hierarchy?.

Thanks,

Jothi

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi,

There is no compounding attribute in my example.

In the screenshot attached, ZCCATEGRY is the technical name of the infoobject in BW system.

0001 is the key value and it's corresponding text is "Alcoholic Beverages".

Thanks,

A Singh

0

Hi,

check the properties of that Info obejct within BEx query.

Display option must be "Key and Text". change to "Text".

Thanks,

Jothi

0