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

[ashutosh_rastogi]

Hello,

Regarding your second question in the post. You wanted to get the measure value for a selection context, I understand this can be done with ResultSet API (Q4 2019 QRC release).

Usages and Scenarios/Examples of ResultSet API (part 1, part 2, part 3, part 4 )

-Ashutosh

[ashutosh_rastogi]

1. Can you elaborate more on the question? In analytics designer you can define global variables within the application, and you can access, use and modify them from within the event code. What do you mean when you say global variables in model definition?
2. You get the dimension members and name of the measure itself, not its values. what is the usecase here?
3. Yes, you can use global variables and use them within the calculations and that way your calculated measure would immediately get altered on the change of global variable.

-Ashutosh

[BhargavaReddy]

Hello Ashutosh,

1. In the model creation window, we can create variables. as shown in the below screenshot.

Can we set a different value for that variable in the analytical application?

In the below screen we have purchase cost slider If I change that value from 0 to 10 then I want to set that value to the variable.

is it possible? in the model, I am setting formulas to measures using with the variable so, I would like to change the value for that variable in the analytical application when the slider event triggered.

2. In my case, I want to send the values of the calculated columns of selected records to the server to update the DB through OData service when user changes are done.

Ex: see above screenshot, I have changed the purchase cost and pressed the updated button.

Thanks & Kind Regards,

Bhargava