SAP BO Analysis Using Filters - SAP BO Analysis Edition For OLAP

How to use filters in SAP BO Analysis?

Filters are utilized to see the information which is pertinent just to your analysis. You can apply filters in the crosstab and in chart as well. Filters can be connected physically by choosing the part from the list or you can characterize a filter condition.

Distinctive filter types are accessible in a workspace. You can filter the analysis dependent on the measure values or it tends to be connected to specific measurements/hierarchies of importance.

Note − Filter based on measures are applied simply to SAP BW data source and the data must be unformatted.

Right-click on the hierarchy that you want to filter, in the Layout panel. Navigate to Filter option → Select by Measure option.

measure_option

Select the target level for the filter, in the “Setting” area on the filter. In Definition area, choose a measure based on the list. In Filter Properties, you can see the list of measure values in the dropdown list.

filter_value


Then, describe a filter type by entering a condition and an operand value. Altered filter types are accessible in Filter condition. If you need to select Top 5 values, you can choose from the dropdown list. Search Top N and enter the Operand value 5 and click on Add.

include_members

Click the OK button at the bottom to put on filter.

How to Edit an Existing Filter?

To edit a current filter, direct to Layout panel → Select hierarchy and right-click → Filter → By Measure → Edit.

existing_filter


The present filter rules are showed in the Filter panel. Add and delete the procedures to describe your altered filter. You cannot openly edit a current rule to change a rule, delete it, and then add the modified rule → Click OK to apply the altered filter to the hierarchy.

modified_rules

How to Delete Filters in an Analysis?

You can physically eliminate a filter or it can be mechanically removed. Every time you substitute hierarchies on the row or column axes, filters are mechanically removed from the analysis.

To remove a filter physically, in Layout panel right-click hierarchy → Filter → By Measure → Delete.

delete_filter

Filter Types

You can relate dissimilar types of filters in an Analysis.

filter_types

Top N

Displays the top N members for the selected level, per parent.(Available for SAP BW flat lists, but not for SAP BW hierarchies.)

Top %

Displays the top contributors to N percent of the parent for the selected level.(Available for SAP BW flat lists, but not for the SAP BW hierarchies.)

Top Sum N

Displays the top members whose cumulative sum is greater than or equal to N. (Available for SAO BW flat lists, but not for SAP BW hierarchies.)

Bottom N

Displays the bottom N members for the selected level, per parent. (Available for SAP BW flat lists, but not for SAP BW hierarchies.)

Bottom %

Displays the bottom contributors to N percent of the parent for the selected level. (Available for SAP BW flat lists, but not for SAP BW hierarchies.)

Bottom Sum N

Displays the bottom members whose cumulative sum is greater than or equal to N. (Available for SAP BW flat lists, but not for SAP BW hierarchies.)

Greater than
  • SAP BW: Displays members that are greater than a specified numeric value.

  • MSAS: Displays members that are greater than a specified numeric value for the selected level.

Outside
  • SAP BW: Displays members that are not within the range specified by two numeric values. Members that are equal to either of the numeric values are not displayed.

  • MSAS: Displays members that are not within the range specified by two numeric values are not displayed.

Between
  • SAP BW: Displays members that are between two specified values, including members that are equal to either of the numeric values.

  • MSAS: Displays members that are between two specified numeric values for the selected level, including members that are equal to either of the numeric values.

Background Filters

In a Study, you can also thin the search by applying filters in hierarchy on the crosstab and these filters are called Background filters.

For suppose if you have data connected to three hierarchies in your Info Cube - Product, Market, and Year. Now you need to see the data connected to year 2015 for all products so you can add Year hierarchy to Background filter. This will display other two hierarchies on the Crosstab axis.

In Background filters, you can add a particular member or multiple members. Background filters are also known as Slice.

background_filter


When you add a hierarchy double-clicks the hierarchy or dimension in the Contextual filter area and this will open the "Filter" panel.
In the Filter panel, you can choose one or more members → Click OK.


filter_panel

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BO Analysis Edition For OLAP Topics