Skip to Content

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”

/wp-content/uploads/2013/04/1asetupspreadsheet_210211.jpg

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.

/wp-content/uploads/2013/04/1combobox_210281.jpg

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

/wp-content/uploads/2013/04/2formatcontrol_210282.jpg

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

/wp-content/uploads/2013/04/3macrovba_210283.jpg

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

/wp-content/uploads/2013/04/4filterinaction_210284.jpg

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

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Alfred Blokland

    thanks, this was very helpfull,

    i have allthough an other question,

    how would this work with multiple data providers, i tried adding one, but then it does not work any more, so far i was only able to make it work by copying the vba code to a second line and change the datasource to the secont one.

     

    regard.

    Alfred

     

    (0) 
    1. Tammy Powlas Post author

      Hi Alfred – thank you for reading and commenting

      I’m not a VBA expert; would you please create this as a question at answers.sap.com ?

      (0) 

Leave a Reply