Open queries in Analytical application

[BhargavaReddy]

Hello SAC Experts,

1) Is it possible to set values to the global variables which are available in the model definition in application event handling?

2) Is it possible to get the details of selected record of a table including calculated measure values which are added in the table itself?

3) Can we able to modify/manipulate table measures data in analytical application which are defined in model without taking additional calculated measures?

Somebody can help me out above queries.

Thanks in advance,

Bhargava

[ashutosh_rastogi · Accepted solution]

Yes, you can access the variable value with new setVariable API. However, if you are on QRC cycle, you would see this API only in 2020 Q1 update. It was release in 2019.22 wave

https://www.sapanalytics.cloud/product_updates/release-2019-22/#_Smart_Insights_enhancements*

Table_1.getDataSource().setVariableValue("variable01", 20); 

For the second case, you can have an invisible KPI with the measure on the application. Set the same filters as that of selection on the KPI tile. And use the value of the same to call your OData API. that should work.

-Ashutosh