Using Range and Exclude Filters
The script API DataSource.setDimensionFilter() supports 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.
The following examples show the use of 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.
-
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 CodeDS_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 CodeDS_1.setDimensionFilter("EMPLOYEE_ID", [{less: "230"}, {greater: "240"}]);