SAC Excel Add In Override

[russellg]

Hi Folks 

When using SAC excel add in on a planning model we have an initial front sheet which allows the users to select the members for executing the planning template against for cost information

We have two more tabs in excel - one for Headcount and one for FTE

The second two tabs should use the same selected members that were used on the initial sheet 

To achieve this I have used the SAP.OVERWRITEDIMENSIONFILTER on the second two tabs referring back to the initial member selection

When i execute a "Refresh All" I am having to then go into each tab and run the refresh all / functions again (sometime 2 or 3 times) to get the override to kick in . Seems flaky

Recording an excel macro does not work and using the Ribbon bar identifier does not work as everyone has different add in for excel so the reference is not consistent

Question

Has anyone figure out how to make the SAP.OVERWRITEDIMENSIONFILTER be executed on the first refresh and bring back the correct data on Tab 2 and 3 ?

Thanks

Russell

[CHOULDER]

Hi Russell,

[CHOULDER]

Hi Russell,

There is a improvement request for this issue raised (SAC add in for Microsoft Excel - automate refresh)

Improvement Request Details - Customer Influence (sap.com)

This has been merged into another request for Adding API methods that can be used in VBA macros. Both for For Long-term Consideration....

regards,

Chris