SAP Analysis Office filter multiple items

Update: Since Analysis 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 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".

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

Now following the following dialog appears.

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 Office Helpfile.

Write a comment

Comments: 0