· 

Analysis Office Show medium text in prompt filter

Until now, we speak of Analysis Office 2.8, if you have different text maintained for an infoobject, Analysis Office shows only the short text in the prompt dialog. The maintenance view of the InfoObject shows all different texts.

Master Data of an InfoObject
Master Data of an InfoObject

But the filter dialog in Analysis Office shows only the short text of this InfoObject and you cannot change it.

Prompt Filter Dialog for specific InfoObject
Prompt Filter Dialog for specific InfoObject

So this is very annoying because sometimes the short text does not explain the selection in a proper way. But there is a solution for this. You have to change the setting Display in the Reporting Properties of the Composite Provider. You find this setting under Output of every Composite Provider for each InfoObject.

Composite Provider Reporting Properties
Composite Provider Reporting Properties

You can change the setting Display to the following options:

  • Key and text
  • Text
  • Key
  • Text and key
  • Long text
  • Medium-length text
  • No display
  • Short text
  • Text and key as short text
  • Text and key as medium text
  • Text and key as long text
  • Key and text as short text
  • Key and text as medium text
  • Key and text as long text

So when you now change it for example to Key and text as medium text, the prompt dialog filter shows the medium text.

Prompt Filter shows medium text
Prompt Filter shows medium text

I hope this help someone to solve a problem. If you have any questions write them in the comments.

author.


I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

You want to know SAP Analysis Office in a perfect detail?
You want to know how to build an Excel Dashboard with your Query in Analysis Office? 
You want to know how functions in SAP Analysis Office works?

 

Then you have to take a look into Analysis Office  - The Comprehensive Guide.


SAP Analysis for Office - The Comprehensive Guide
The book SAP Analysis for Office - The Comprehensive Guide by Tobias Meyer is a pdf book about SAP Analysis for Office. It is based on Analysis for Office 2.8 and contains 346 Pages.
45,00 €
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.7 and contains 299 Pages.
37,00 €

Write a comment

Comments: 4
  • #1

    Karan Sehjpal (Wednesday, 25 November 2020 05:44)

    in the prompt it always take key value, there is no way we can input text.

    Any thoughts.

    Regards
    karan

  • #2

    Tobias (Thursday, 26 November 2020 08:08)

    Hi Karan,

    you are right, in this post it is about the filter dialog you also have in the prompt and not the prompt itself. But it is helpful when you use the filter to get more than a key value.

    Best regards,

    Tobias

  • #3

    Mahesh (Monday, 26 April 2021 14:45)

    Hi ,

    Analysis for office prompts (AO 2.0 sps8)are disabled and coming up when executing any report connecting with HANA 2.0 SPS5.
    Please suggest us with your valid inputs.

  • #4

    Tobias (Monday, 26 April 2021)

    Hi Mahesh,

    can you specify our problem? Did you have any input variables? If it is to complex you can write me an email.