reyemsaibot

SAP BI Blog about SAP BW/4HANA, Analysis for Office and SAP HANA - by Tobias Meyer

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.

Kommentare

2 Kommentare zu „Analysis Office Filter by Member Attribute“

  1. Avatar von Maja
    Maja

    Thank you, this was helpful to me!

  2. Avatar von JASV
    JASV

    Great Info. Thanks

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert