I have a requirement to filter the HANA data source based on calculation view with value range in Design studio dashboard.
I tried the following:
Defined a range variable in HANA studio as shown below (also tried using interval and Multiple entries)
and used the following code in design studio to filter data.
DateRange = StartDate + "-" + EndDate;
DS_2.setVariableValueExt("VAR_CreateDt", DateRange); and DS_2.setVariableValue("CreateDt", DateRange);
Also tried using DS_2.setFilterExt("CreateDt", DateRange); and DS_2.setFilter("CreateDt", DateRange);
Data is not being filtered by any of these procedures.
Any suggestions to filter data with range of values are really helpful for my requirements. Thank you in advance for your time.