SAPSetVariable Does Not Work

[Kemaley]

Hello everyone, SAPSetVariable function is not working. I share the code below. lResult returns 0. Thanks in advance...

Sub TestSon()

Refresh = Application.Run("SAPExecuteCommand", "RefreshData", "DS_1")
lResult= Application.Run("SAPSetVariable", "OP_DATE_OPEN", "08.07.2024", "", "DS_1")

End Sub

[MKreitlein]

Hello @Kemaley 

first of all, you should always give the AO version, you are currently using. I chose this link:

https://help.sap.com/docs/SAP_BUSINESSOBJECTS_ANALYSIS_OFFICE/ca9c58444d64420d99d6c136a3207632/f2713... 

... and you can see that there is one additional parameter, which might be helpful:

• Text - Single member as text.
• Key - Single member as key.
• INTERNAL_KEY - Single member with its internal key.
• INPUT_STRING - Complex selection of members.
• INPUT_STRING_AS_ARRAY - Returns the input string as string as array.
• LITERAL - Single member with its internal key.

Maybe you try this again:

lResult= Application.Run("SAPSetVariable", "OP_DATE_OPEN", "08.07.2024", "KEY", "DS_1")

or the INTERNAL_KEY, which should be 20240708

BR, Martin

[Kemaley]

First of all, thank you for taking the time to respond. I tried all versions one by one. It refreshes the data, but the prompt part does not work. I couldn't understand the reason. When I searched it on the internet, it actually seems very easy. But I can't figure out what's missing.

[Kemaley]

My AO version is 2.8