Skip to Content
author's profile photo Former Member
Former Member

BO Analysis - texts are not shown for hierarchy nodes in prompt / variable screen

Hi Experts,

I have a short question related to hierarchy nodes in BO Analysis for Microsoft Excel.

In the prompt on the variable screen the texts for the hierarchy nodes are not shown. In the Analysis workbook in excel the texts are shown.

As you can see i have selected Member(text) in the prompt screen . Still it shows me the hierarchy node key instead of text.

I am on this version of BO Analysis.

But when i run the BEx query behind this report in BO Analysis for Microsoft Excel, it runs fine and i can see the text in analyzer.

Is there a setting that i can change in BW system or is it a product issue and i will need SAP Notes to resolve this issue.


Ashutosh Singh

Issue in Afo.PNG (92.2 kB)
AFO version.PNG (31.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Dec 09, 2015 at 12:05 PM

    Hello - please see this thread Display Text and Key of Hierarchy-Variable valu... | SCN and check your InfoObject settings

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Tammy Powlas

      Hello Tammy,

      Finally i got the solution . I changed the provider specific properties of the info object "0costcenter" inside the cube "0cca_c11" as shown below . Before it was "Long Text" and in our system "Long text" for cost center does not exist. :

      Then i got the text of the hierarchy nodes in the prompt screen of the analysis for office.

      Thanks for the suggestions. I am closing the thread now.


      Ashutosh Singh

      Issue in Afo6.PNG (35.7 kB)
  • Posted on Dec 10, 2015 at 10:10 AM


    The text is shown on the left side of the prompt screen.

    Prompts.png (6.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 18, 2016 at 10:27 AM

    Hi Ashutosh,

    I am not able to see Hierarchy display in AO prompt screen.

    I am viewing HANA calculation view, in AO (version 2.1.0). I have created a Hierarchy variable on a Dimension.

    When I do data preview in HANA studio, I can see hierarchy structure in search option for this field. but in Analysis for office it only shows Key and Text.

    It means AO is not reading Hierarchy structure at the time of search help (F4).

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.