Skip to Content
Sep 30, 2019 at 04:06 PM

setDimensionFilter not working



I want to filter in an analytic application dynamicall on 0FISCYEAR and 0FISCPER3.

If used the following code:

// Filter Year
var year_id = 'K4/' + Dropdown_Year.getSelectedKey();
TablePandL.getDataSource().setDimensionFilter("0FISCYEAR", year_id);

// Filter Posting Period
var period_id = '1';
TablePandL.getDataSource().setDimensionFilter("0FISCPER3", period_id);

To keep it easy I set the period_id to 1, which should filter first period (January).

When I run the application I get the following error:

If I only set the dimension filter for 0FISCPER3 I get the same message for this dimension.

How can I set the filter for those to fields with the setDimensionFilter method?

How can I set a filter on multiple values for 0FISCPER3?

Thanks for your help in advance!

Best Thomas

System Configuration: SAC with Live-Connection to BW 7.5 SP14, HANA 2.0, all SAC notes applied


errorfilter.png (10.2 kB)