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!
System Configuration: SAC with Live-Connection to BW 7.5 SP14, HANA 2.0, all SAC notes applied