Question Re: function SAPGetVariable in Technology Q&A

function SAPGetVariable

Former Member — Wed, 08 Jan 2014 15:39:51 GMT

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 — Thu, 09 Jan 2014 04:31:32 GMT

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 — Thu, 09 Jan 2014 09:08:35 GMT

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 — Thu, 09 Jan 2014 11:18:00 GMT

Hi Yong,

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

Regards,

Bharath

Former Member — Wed, 15 Jan 2014 11:05:28 GMT

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