function SAPGetVariable

[Former Member]

Dear all,

we are using the function "SAPGetVariable" to display the values specified for BW variables in the report title.

=SAPGetVariable("DS_1"; "VAR_1";"VALUE")

In most cases, the function returns the value in the format: key text. (e.g. Company Code: DE00 Germany).

Funny is the funciton with the hierarchy variable. It returns also the value but in another format: text (key).

Is there any possibility to get the key and text for variable separatly or get the value in same format?

Thanks in advance

Yong

[bharathsap]

Hi Yong,

There is an additional (optional) parameter available which can be used to get value/value as Key.

See below screenshot for more info. I guess this should help your cause.

Regards,

Bharath

[Former Member]

Hi Bharath,

thanks for your reply.

It would be then perfect if there was another property name for text. Then I could combine the key and text in any format required by the business.

Best regards

Yong

[bharathsap]

Hi Yong,

There is no property to show text. You can suggest this usecase in ideas place -

https://ideas.sap.com/ct/ct_list.bix?c=74624057-8A9E-4511-844E-2399DFBF5EE8

Regards,

Bharath

[Former Member]

Hello Yong,

whenever you have the technical name for a dimension member, you can easily get its respective text by using the SAPGetMember formula.

Regards!

Ricardo Vieira