Skip to Content
0

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

Jan 12, 2017 at 12:17 PM

146

avatar image

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

lh0xv.jpeg (6.5 kB)
jycl5.jpeg (8.1 kB)
vvfkq.jpeg (8.5 kB)
za0ix.jpeg (7.0 kB)
eauva.jpeg (6.8 kB)
2z5jx.jpeg (8.4 kB)
vo1hq.jpeg (8.5 kB)
dxqzy.jpeg (9.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Tammy Powlas
Jan 12, 2017 at 12:37 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Jan 12, 2017 at 12:42 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Claudia Tozzi Jan 19, 2017 at 03:40 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded