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.
But the filter dialog in Analysis Office shows only the short text of this InfoObject and you cannot change it.
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.
You can change the setting Display to the following options:
- Key and text
- 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.
I hope this help someone to solve a problem. If you have any questions write them in the comments.
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.
Write a comment
Karan Sehjpal (Wednesday, 25 November 2020 05:44)
in the prompt it always take key value, there is no way we can input text.
Tobias (Thursday, 26 November 2020 08:08)
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.
Mahesh (Monday, 26 April 2021 14:45)
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.
Tobias (Monday, 26 April 2021)
can you specify our problem? Did you have any input variables? If it is to complex you can write me an email.