· 

SAP Analysis for Office filter multiple items

Update: Since Analysis for Office 2.3 you also can filter your data by uploading a file.

There is either the chance to filter multiple items directly when you refresh a query in Analysis for Office. To use this option you have to click on the arrow on the plus button. A menu will be open and then you choose the entry "Add Lines Using Filter by Member".

SAP Analysis for Office Add Lines Using Filter by Member
Analysis Office Add Lines Using Filter by Member

Now following the following dialog appears.

SAP Analysis for Office: Filter by Member
Filter by Member

There you can either select everything by hand or you click on the small button on the left. This button adds the items from your clipboard. If you want to realize a filter with VBA, you have to use the command =SAPSetVariable. You find more information in the Analysis for Office Helpfile.

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 €

Write a comment

Comments: 0