Skip to Content

BPC 10 refresh issues in VBA Macro. Not updating context member when refreshing

Nov 09, 2017 at 11:43 AM


avatar image

We have a macro setup to run P&Ls for all our profit centers. The macro switches the profit center in the context and then does a workbook refresh, paste values the file, and then saves. In the past 2 months we've had an issue where even though the context is being updated with the profit center we want to run the template is refreshing a profit center that is not even within the list that we are running. Which has us ending up with a bunch of excel reports with the same data saved for each one and having to rerun. What would cause BPC to pull a profit center that is not in our list and have that be applied to our template? Is there a cache refresh or something else needed before we start our run?

I believe they are running SP26_patch3

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Nov 09, 2017 at 03:29 PM

Sorry, but it's impossible to discuss the VBA macro issue without providing full code.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

We actually figured out that it was an issue with a group of our servers. Thanks for your response though.