Skip to Content

Analysis for OLAP prompts display as text instead of key

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 23, 2016 at 07:52 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25, 2017 at 03:05 PM

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

    Add comment
    10|10000 characters needed characters exceeded