Analysis for Office: recap of the input parameter set in the prompt as key and text

[Former Member]

Hi everyone,

i’m building some Analysis for Office reports. The objective I’d like to reach is the possibility to show in the sheet a recap of all input parameters set in the prompt as key and text (not only key or text).

I used ‘Info Field’ and ‘Variables’ functionality (Figure 1).

Figure 1

The code created by default using the function above is the following:

=SAPListOfVariables("ALL").

My Analysis for Office version is 1.4, but we are upgrading to the 2.3 version.

I try to explain the behavior of this functionality.

If I put in the prompt an input parameter displaying Key (Figure 2),

Figure 2

in the sheet i see correctly the key of the dimension (Figure 3).

Figure 3

If I put in the prompt an input parameter displaying Text (Figure 4),

Figure 4

in the sheet i see correctly the text of the dimension (Figure 5).

Figure 5

The strange behavior starts if I set in the prompt an input parameter displaying Key and Text (Figure 6),

Figure 6

because in the sheet I continue to see only key (figure 7).

Figure 7

Same thing if I set in the prompt an input parameter displaying before Text and then Key (Figure 8); the sheet shows only the text.

Figure 8

Do you know if is there a way that can permit us to see in the sheet both key and text of a variable?

Do you know also if this behavior could be due to our Analysis for Office version? It is possible that after the upgrade we will not have this issue?

Thanks in advance,

Claudia

[Former Member]

Hi Tammy,

thanks for your answer. I have no BEx query, but Hana Stand Alone. Anyway the behavoiur is the same. Thanks for the link above.

Claudia

[TammyPowlas]

Some alternative ways you can try can be found in this thread: https://archive.sap.com/discussions/thread/3147486

[TammyPowlas]

Claudia - I just tried it on 2.4 and experience the same. It seems to default to what the settings were in the BEx query. In my example, defaults are to text. If I change the display to key and text, there is no influence on it, even with a refresh.