cancel
Showing results for 
Search instead for 
Did you mean: 

Change Measure Value From Key to Text

Former Member
0 Kudos

I  created a macro to populate a filter with values from a list .

LResult = Application.Run("SAPSetFilter", "DS_1", "GLFMRPRID__GLFMRMOLC", vntData, "INPUT_STRING")

In order to get the macro to work, I had to have the field values listed as the key value instead of the text value (e.g. "MC0592" is displayed instead of "Serbia").  At the end of the macro, I would like to convert back from key to display the actual text,  I reviewed the User Guide: Sap  BusinessObjects Analysis, edition for Microsoft Office sections 3.4 and 3.6 on working with formulas and working with macros, but have not been able to identify a formula or API which will do the trick.  An Internet search came up empty as well.

Any help will be appreciated.

Accepted Solutions (0)

Answers (1)

Answers (1)

filipe_zeuch
Employee
Employee
0 Kudos

Hi,


Did you check the function "SAPGetMember"?
I am not sure exactly if I understood your scenario, but this function will return the text of the member based on the key that you enter for the second parameter.


For example:
SAPGetMember("DS_1";"GLFMRPRID__GLFMRMOLC=MC0592";"TEXT")

This should return "Serbia" assuming that the technical name of your dimension is "GLFMRPRID__GLFMRMOLC".