Skip to Content
0

Dimension filter in Design studio

Apr 07, 2017 at 02:11 AM

359

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Apr 07, 2017 at 09:28 AM
0

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);
Share
10 |10000 characters needed characters left characters exceeded
Mustafa Bensan Apr 09, 2017 at 04:25 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded