Skip to Content
avatar image
Former Member

Dimension filter in Design studio

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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);
    Add comment
    10|10000 characters needed characters exceeded

  • 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.

    Add comment
    10|10000 characters needed characters exceeded