Skip to Content
Former Member
May 21, 2008 at 01:13 PM

BEx Analyzer 04s: Set filter values for multiple dataproviders per VBA


Hello Forum and Analyzer Experts,

I need your help very much to set one filter values for multiple dataproviders in one workbook with one dataprovider on each worksheet.

The characteristic contains an hierarchy with > 100 items. This is the reason we can't use the DropDown-Item. With this item, we can choose influenced dataproviders.

Our aim is to do this with navigation panes.

I've tried to start setting filters by button with a corresponding command area. This button was "clicked" in my refresh sub, what results and endless loop.

Has anyone an idea to set the filter settings? Points will be assigned.