Skip to Content

SAP Design Studio Filtered Data source returning different number of rows.

Not sure why but in this code the data source is returning different number of rows.

DS_EXCEPTIONS.setFilter("ZKPICATC2", CHART_1.getSelectedMember("ZKPICATC2"));
DS_EXCEPTIONS.setFilter(RangeType, CHART_1.getSelectedMember(RangeType));

var exceptions1 = DS_EXCEPTIONS.getMembers("ZKPICH31", 50);
var exceptions2 = DS_EXCEPTIONS.getMembers("ZKPICH32", 50);
var exceptions3 = DS_EXCEPTIONS.getMembers("ZKPICH33", 50);
var exceptions4 = DS_EXCEPTIONS.getMembers("ZKPICH34", 50);

APPLICATION.log(Convert.floatToString(exceptions1.length) + '-' + Convert.floatToString(exceptions2.length ) + '-' + Convert.floatToString(exceptions3.length) + '-' + Convert.floatToString(exceptions4.length));

So exceptions1 returns 8 rows and exceptions2-3-4 all return 3 rows. They all contain different data and they all contain data, so it is not because it is aggregating. The data source is BW.

Thanks for your help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 08, 2017 at 02:46 PM

    Hi Justin,

    For easier analysis of your issue, it would be helpful if you posted a screenshot of your application, showing the chart, highlighting the selection and then also showing the filtered results with all four exception dimensions displayed in a Crosstab, as well as an explanation of how the RangeType variable is populated.

    Normally, with a cascading filter setup, I would expect a result more along the lines of Exceptions 1, 3 and 4 returning the same number of items, since Exception 2 is used as one of the filters. It's possible that the returned member values are out of sync because the Members for Filtering attribute of each of the Exception dimensions as well as RangeType dimension have not been set consistently. Please check in your data source initial view editor that each of these dimensions has the said attribute set to "Values in Posted Data Only".



    Add comment
    10|10000 characters needed characters exceeded