SAPCallMemberSelector and range values

[Former Member]

Hi,

I'm trying to get the range of a variable which is set through a prompt in order to assign new values to this variable and rerun the query via VBA.

In the prompt two input boxes for this variable are shown. So I assume that the following command:

Dim vResult as Variant

vResult = Application.Run("SAPCallMemberSelector", "DS_1", "PROMPT", "VARIABLE")

delivers the entered values. Unfortunately the variable "vResult" is empty and does not return any error.

Since the documentation says that the function "SAPCallMemberSelector" only returns three kinds of return types and in my case the function neither returns an error nor "False", I assume that "SAPCallMemberSelector" can't handle range values. I'm using Analysis 1.4 SP8.

Am I doing something wrong or is the function "SAPCallMemberSelector" not able to handle range values?

Regards

Andreas

[Former Member]

Hi Andreas,

I would recommend this Blog posting:

http://scn.sap.com/community/businessobjects-analysis-ms-office/blog/2013/07/15/roll-your-own-analys...

when you check the comments from Aug. 29, ( http://scn.sap.com/community/businessobjects-analysis-ms-office/blog/2013/07/15/roll-your-own-analys... ) you can see a discussion from myself about getting the list of variables, which could be stored in an array and that you need to distinguish the access to it.

So, could it be that you are actually looking for: =SAPListOfVariables("DS_x";"KEY";"PROMPTS") ?

Regards, Martin