cancel
Showing results for 
Search instead for 
Did you mean: 

WEBi List of values for Hierarchy prompt based on BW query

former_member580444
Discoverer
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

jyothirmayee_s
Active Contributor
0 Kudos

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

former_member580444
Discoverer
0 Kudos

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

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

check the properties of that Info obejct within BEx query.

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

Thanks,

Jothi