Skip to Content
avatar image
Former Member

Dimension filter in Design studio

Apr 07, 2017 at 02:11 AM | 586 Views

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

SAP BusinessObjects Design Studio
SAP BusinessObjects Business Intelligence platform
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Koen Hesters
    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

  • avatar image
    Mustafa Bensan
    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