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.

Regards,

Tobias