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.

author.


I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

SAP Analysis for Office - The Comprehensive Guide
The book SAP Analysis for Office - The Comprehensive Guide by Tobias Meyer is a pdf book about SAP Analysis for Office. It is based on Analysis for Office 2.8 and contains 346 Pages.
45,00 €
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.7 and contains 299 Pages.
37,00 €
SAP Analysis for Office - The Comprehensive Guide
SAP Analysis for Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis for Office. It is based on Analysis for Office 2.6 and contains 272 Pages.
27,00 €

Write a comment

Comments: 2
  • #1

    Maja (Wednesday, 19 August 2020 09:18)

    Thank you, this was helpful to me!

  • #2

    JASV (Thursday, 22 June 2023 16:52)

    Great Info. Thanks