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.
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.
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.
Click the OK button at the bottom to put on filter.
To edit a current filter, direct to Layout panel → Select hierarchy and right-click → Filter → By Measure → Edit.
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.
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.
You can relate dissimilar types of filters in an Analysis.
|Top Sum N|
|Bottom Sum N|
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.
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.
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.