How to SetFilter with Analysis Office Macros

[TammyPowlas]

For your end users, you may want to set up filters so they do not need to use the Design Panel in Analysis Office.

I've already inserted a query in Analysis Office, and created a second sheet named "settings"

I set up the data as shown above, and set up the Index formula to track where the combo box is on the selection tab.

On the first sheet with the query I select the combo box from the Developer ribbon.

Using the context menu I select Format Control as shown above.

Using the context menu I select Assign Macro and copy in the code from above.  I will filter on Info Object project.

The above shows it in action, with the combo box filtering on the Maintenance project.