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
Apr 07, 2017 at 09:28 AM
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);
Apr 09, 2017 at 04:25 PM
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.