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]

Thanks Dixit,

I have since found this document that I think everyone will find very helpful.

SAP Analytics Cloud – Sample Content: Generic Analysis application – URL parameter | SAP Blogs

Regards,

-Norm

[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

[avsalynin]

vitran23

as i remember, we can pass []

Table_1.getDataSource().setVariableValue(VARIABLE,[value1,value2,value3]);

[vitran23]

That is defining an array of single values. What I'm looking for is the proper coding to set a range value.