SAP Analytics Cloud - Passing Variable Date Range to BW Live Datasource?

[vitran23]

Within SAP Analytics Cloud - Analytic Application, how do you set a variable that is a range value?

Example: the BW query needs a range of 1/2022 - 3/2022, how does I set that in Analytic Application scripting.

[norman]

Hi All,

Has anyone found a solution to this question yet? This is easy to accomplish in Webi with the UserResponse function to get the BW variable(prompt), create a webi variable to parse the data, and then passing it in the opendoc formlar?

[former_member854957]

Hi Norman,

Range Variable values can be give as:

Table_1.getDataSource().setVariableValue(VARIABLE,{from:"fromValueId", to: "toValueId"});

I hope this helps.

Regards

Dixit