reyemsaibot

SAP BI Blog about SAP BW/4HANA, Analysis for Office and SAP HANA - by Tobias Meyer

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.

Kommentare

4 Kommentare zu „Analysis Office Show medium text in prompt filter“

  1. Avatar von Karan Sehjpal
    Karan Sehjpal

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

  2. Avatar von Tobias
    Tobias

    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. Avatar von Tobias
    Tobias

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

  4. Avatar von Mahesh
    Mahesh

    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.

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert