Filter By Measure in Analytics Designer

[rahulkumarsap]

Hi Experts

I am using live HANA connection.

How do I define filter by measure on a calculated measure in analytics designer of SAC?

[saurabh_sonawane]

Hi ,

step 1 create a calculated measure inside the model only

step 2 use that measure to filter the data

Thanks,

Saurabh S.

[robert_schmidt01]

- Could you move the calculated measure in Analytics Designer into your HANA model by creating a Calculated Column?

-Formula could be something like
Name: CalCol
Formula: if (x/y > '$$IP_FILTERVAL$$', 1, else 0)

-Then you could apply a filter where CalCol = 1.

- IP_FILTERVAL is an input parameter.

--------------------------------------------------------

- Code in Analytics Designer would be similar to:
var dsSI = tblStatistics.getDataSource();
dsSI.setVariableValue("IP_FILTERVAL", dblLimit);