Skip to Content
0

Analysis for OLAP prompts display as text instead of key

Dec 23, 2016 at 05:23 PM

197

avatar image

We need to display Analysis for OLAP prompts as text instead of key. This is important when a prompt is on a hierarchy such as profit center and we set a default value in the bex query.

NOTE: This is not for ANALYSIS for OFFICE. There is not a primary tag for AOLAP?

The user is presented with the technical id of the hierarchy node instead of the description, so 1000CO_RTC instead of the nodes description Rush Truck Centers.

There is also more junk on the end to confuse users- 10000CO_RTC(Text\Node)

This behavior is the same for non-hierarchy prompts such as Sales Person; we want to default the person's name and not display just their personnel number.

There does not appear to be any way to control the display of prompt values in AOLAP. And the bex query characteristic display properties are ignored, as the example above, the property for profit center is text and key. We are on Version 4.1 SP6.

Any advice on this is greatly appreciated.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Thomas Zarebczan Dec 23, 2016 at 07:52 PM
0

You may have to concatenate the text and key when loading the object, and just show text using the IO Setting for BEx F4 Values. Text and Key, Key and Text options don't work on the BOBJ side.

Share
10 |10000 characters needed characters left characters exceeded
Lee Lewis Jan 25, 2017 at 03:05 PM
0

Thanks for your suggestion, but will not meet the requirement. I do appreciate it!

Share
10 |10000 characters needed characters left characters exceeded