Hi,
I have built dimension filter on Bex query in design studio, i want to pass the filter to chart (which built on SAP HANA view), Please let me know how I can pass selected dimension value to data source built based on HANA data source.
Thanks,
Guna
Hi,
I presume you add the bex filter as a variable, so you can use on startup:
var filter = DS_1.getVariableValueExt("BUS_DOSTYP");
If you have use a hardcoded filter in bex you can simply hardcode it in design studio for your chart
DS_2.setFilter(dimension, value);
Hi Guna,
You can apply the following code in the "On Apply" event script of the Dimension Filter component linked to your BEx Query to copy the selected filter value to the HANA data source:
DS_BExQuery.copyFilter(HANA_View_Dimension, DS_HANA_View, DimensionFilterDimension);
Regards,
Mustafa.