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.


Analysis Office - The Comprehensive Guide 5th edit
The book SAP Analysis 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.
59,99 €
Analysis Office - The Comprehensive Guide 4th edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.7 and contains 299 Pages.
39,99 €

Write a comment

Comments: 0