Analysis Office Filter by Member Attribute

Crosstab before Filter by Member Attribute
Crosstab before Filter by Member Attribute

A feature which I didn't know even it is available since Analysis Office 2.2 is to search and filter by attribute. First select a dimension you want to filter.

Filter by Member via Context Menu
Filter by Member via Context Menu

Now you see the Filter by Member dialog and you can display the necessary attribute you want to filter.

Filter by Member Dialog
Filter by Member Dialog

Now select in the dropdown menu the attribute you want to filter.

Filter by Member Select Attribute
Filter by Member Select Attribute

After you select the attribute, you can use the search bar to filter your result.

Filter by Member via Attribute
Filter by Member via Attribute

The result of the crosstab should look like the following screenshot.

Crosstab after Filter by Member
Crosstab after Filter by Member

So as you can see, you cannot only Filter by Member for a dimension, you can also Filter By Member for an attribute. This might be interesting for you, when you use a lot of attributes.

Analysis Office - The Comprehensive Guide 3rd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.6 and contains 272 Pages.
49,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €
Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
9,99 €

Write a comment

Comments: 0