Skip to Content

BPC 10.1 Save data copied with VBA macro

Mar 29, 2017 at 04:20 PM


avatar image

Hi everyone,
I am working with a planning schedule on BPC 10.1 embedded and I need to copy the data that I write into a column into another, then save the data to the cube.
I use a button with a macro that copies the data into the second column and then performs the "PlanDataSave" command.
Despite the values are correctly copied into the second column, they are not sent to the cube and also the save data button in the excel planning tab is gray. If I manually copy and paste the values i am able to save them to the cube so I think there's some kind of event to be triggered after the VBA copy.
Do someone knows how to do that?


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

0 Answers