Use API on Range and Exclude Filters

As an application designer or story developer, you can use script API DataSource.setDimensionFilter() on range filters and exclude filters.

Exclude Filters

You can filter out members from the drill-down with exclude filters. The following examples show the use of exclude filters:
  • In the following example, a single filter value is set for dimension "EMPLOYEE_ID". This keeps only the member with employee ID 230 in the drill-down:
    Sample Code
    DS_1.setDimensionFilter("EMPLOYEE_ID", {value: "230"});
  • In the following example, a single but excluding filter value is set for dimension "EMPLOYEE_ID". This removes the member with employee ID 230 from the drill-down:
    Sample Code
    DS_1.setDimensionFilter("EMPLOYEE_ID", {value: "230", exclude: true});
  • In the following example, multiple filter values are set for dimension "EMPLOYEE_ID". This keeps the members with employee IDs 230 and 240 in the drill-down:
    Sample Code
    DS_1.setDimensionFilter("EMPLOYEE_ID", {values: ["230", "240"]});
  • In the following example, multiple but excluding filter values are set for dimension "EMPLOYEE_ID". This removes the members with employee IDs 230 and 240 from the drill-down:
    Sample Code
    DS_1.setDimensionFilter("EMPLOYEE_ID", {values: ["230", "240"], exclude: true});

Range Filters

You can filter ranges of members in the drill-down with range filters.
Note
Please note the following when using range filters:
  • Range filters can only be applied to numeric dimensions.

  • A time dimension is not a numeric dimension.

  • SAP BW does not support numeric dimensions.

The following examples show the use of range filters:
  • In the following example, the range filter applied to dimension "EMPLOYEE_ID" keeps the members with employee IDs between 230 and 240 in the drill-down:
    Sample Code
    DS_1.setDimensionFilter("EMPLOYEE_ID", {from: "230", to: "240"});
  • In the following example, the range filter applied to dimension "EMPLOYEE_ID" keeps the members with employee IDs less than 230 in the drill-down:
    Sample Code
    DS_1.setDimensionFilter("EMPLOYEE_ID", {less: "230"});
  • In the following example, the range filter applied to dimension "EMPLOYEE_ID" keeps the members with employee IDs less or equal than 230 in the drill-down:
    Sample Code
    DS_1.setDimensionFilter("EMPLOYEE_ID", {lessOrEqual: "230"});
  • In the following example, the range filter applied to dimension "EMPLOYEE_ID" keeps the members with employee IDs greater or equal than 230 in the drill-down:
    Sample Code
    DS_1.setDimensionFilter("EMPLOYEE_ID", {greaterOrEqual: "230"});
  • In the following example, the range filter applied to dimension "EMPLOYEE_ID" keeps the members with employee IDs greater than 230 in the drill-down:

    Sample Code
    DS_1.setDimensionFilter("EMPLOYEE_ID", {greater: "230"});
  • You can also apply multiple range filters at once.

    In the following example, the range filter applied to dimension "EMPLOYEE_ID" keeps the members with employee IDs less than 230 and greater than 240 in the drill-down:

    Sample Code
    DS_1.setDimensionFilter("EMPLOYEE_ID", [{less: "230"}, {greater: "240"}]);