on 01-30-2015 7:35 PM
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.
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".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.