The data displayed in BPO dashboards can be restricted by setting filters on the level of analytical key figure instances. For an AKFI, you can set multiple filters.
To set up a filter:
In Setup BPO Dashboards, on the Setup Analytical Key figure Instance tab, select an analytical key figure instance, and choose Change.
in the Filter Characteristic screen area, choose Add Filter Element.
A window for the filter setup appears.
Enter the filter characteristic for which you want to set a filter.
There are the following filter characteristic types:
Time characteristic, for example, Calendar day or Calendar week.
System characteristics, for example, System ID or Monitoring ID.
Analytical key figure specific characteristics, for example, sales organization. Which specific characteristics are available depends on the selected key figure.
Select a filter type. The following filter types are available:
Regular filter
Relative filter
Runtime filter
Filter for Top N characteristic values
Save your entries.
Note
You can maintain more than one filter for one AKFI. However, you can use only one filter on time characteristics per AKFI.
A regular filter directly filters certain values of a filter characteristic. Regular filters can be used with all filter characteristics.
Typical use case: You want to display data for a single sales organization only.
In Setup BPO Dashboards, on the Setup Analytical Key figure Instance tab, select an analytical key figure instance, and choose Change.
Choose Add Filter Element.
Select the filter characteristics and the Regular Filter filter type.
To define a select option, enter the following data:
Sign (mandatory): I (Include) or E (Exclude)
Note
For time characteristics, only I (Include) is supported.
Option (mandatory): EQ (Equal), BT (Between)
Note
For time characteristics, only BT (Between) is supported.
Low (mandatory): Enter a characteristic value you want to exclude or include in the filter.
High (optional): If you want to exclude or include a range of characteristic values, enter values for Low and High.
Choose Add to add the select option to the filter.
To define more select options, repeat steps 1 to 3.
Save your entries.
Note
You cannot change the settings in the filter after saving. You can only delete the filter and create a new one.
Using a relative filter, you can filter dynamically. Relative filters can only be used for time characteristics.
Typical use case: You want to display data from the last ten days.
In Setup BPO Dashboards, on the Setup Analytical Key figure Instance tab, select an analytical key figure instance, and choose Change.
Choose Add Filter Element.
Select the filter characteristics and the Relative Filter filter type.
To define a select option, enter the following data:
Sign (mandatory): I (Include)
Note
Even though exclude can be selected, it is not supported.
Option (mandatory): BT (Between)
Low (mandatory): Enter the lowest value of a relative range.
High (mandatory): Enter the highest value of a relative range.
Choose Add to add the select option to the filter.
Save your entries.
Note
You cannot change the settings in the filter after saving. You can only delete the filter and create a new one.
With runtime filters, you can define category and drilldown characteristics. The system applies runtime filters during runtime when a panel calls a detail panel.
In Setup BPO Dashboards, on the Setup Analytical Key figure Instance tab, select an analytical key figure instance and choose Change.
Choose Add Filter Element.
Select the filter characteristics and the Runtime Filter filter type.
To define a select option, enter the following data:
Sign (mandatory): I (Include) or E (Exclude)
Note
For time characteristics, only I (Include) is supported.
Option (mandatory): EQ (Equal), BT (Between)
Note
For time characteristics, only BT (Between) is supported.
Low (mandatory): Enter a characteristic value you want to exclude or include in the filter.
High (optional): If you want to exclude or include a range of characteristic values, enter values for Low and High.
Choose Add to add the select option to the filter.
To define more select options, repeat steps 1 to 5.
Save your entries.
Note
You cannot change the settings in the filter after saving. You can only delete the filter and create a new one.
With the filter for top n characteristic values, you can filter for only the highest values of the selected filter characteristic.
The top n filter cannot be used with time characteristics.
In Setup BPO Dashboards, on the Setup Analytical Key figure Instance tab, select an analytical key figure instance, and choose Change.
Choose Add Filter Element.
Select the filter type Filter for Top N Characteristic Values.
Choose how many values you want to display in the AKFI panel.
Save your entries.
Note
You cannot change the settings in the filter after saving. You can only delete the filter and create a new one.
Note
When using the filter for top n characteristic values in combination with other filters, set the filter for top n characteristic values as the last filter. Otherwise, all other filters are not taken into account.
After saving a filter, the filter appears in the Analytical Keyfigure Details screen in the Filter Characteristic screen area.
To display the select options for a filter in the Select Options screen area, select a filter.
To delete a filter, select it and choose Remove Filter Element.
To add a new filter, choose Add Filter Element.
Note
You can maintain more than one filter for one AKFI. However, you can use only one filter on time characteristics per AKFI.
The Maintain Thresholds pushbutton is only available to display analytical key figure instances that were created in a previous version of BPO dashboards, and were transported to SAP Solution Manager 7.1 SP05 and higher during an update.
We recommend that you set filters as specifically as possible. When you set a specific filter (for example, on solution and monitoring ID), you restrict the amount of data to be evaluated. This improves the performance when calling the dashboard, that is, the data is displayed faster.
Note
Filtering is especially important when using the detail list connector. The detail list connector only works if a filter to only a single detail list is set. Otherwise, an error occurs. A detail list is uniquely identified by system, client, solution, and monitoring ID.
In BPO dashboards, to refer directly to key figures from SAP Business Process Analytics or SAP Business Process Monitoring, set a filter on SM_MONID (monitoring ID) and SM_SOLUT (solution monitoring ID).
Key figures in SAP Business Process Monitoring and SAP Business Process Analytics always refer to a specific collector set up in a specified solution (from Business Process Monitoring Setup). In contrast, AKFIs in the BPO dashboards refer to single collector setups, and even across solutions, to the data of all monitors set up for a certain key figure in Business Process Monitoring Setup.
Therefore, to avoid displaying mixed up cross collector data in BPO dashboards, we recommend that you filter on monitoring ID and solution monitoring ID.
To refer directly to key figures from SAP Business Process Analytics or SAP Business Process Monitoring in BPO dashboards:
In the SAP Solution Manager Business Process Operations work center, choose Setup Business Process Monitoring.
The Business Process Monitoring Setup screen appears.
For the key figure you want to use in BPO dashboards, navigate to the Monitoring Collector Setup.
Choose Technical Information.
From Technical Information, copy the monitoring ID and solution monitoring ID.
In BPO dashboards, create an AKFI for the key figure.
Create the following filters on the AKFI:
Create a regular filter for the SM_SOLUT filter characteristic:
Sign = I
Option = EQ
Low = the solution monitoring ID you copied in step 4 from SAP Business Process Analytics
Choose Add and save your entries.
Create a regular filter for the SM_MONID filter characteristic:
Sign = I
Option = EQ
Low = the monitoring ID you copied in step 4 from SAP Business Process Analytics
Choose Add and save your entries.