Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BPC application - global data environment

Hi SCN

I have a workbook using BPC 10 with a global declaration in a VBA module which is set when the data from BPC is refreshed.  When operating the workbook, this Boolean is tested - if not set, the code requires the user to refresh.

This refresh is time consuming and for some reason, the global data is initialised yet there is no code to do this and a watch-point on the global does not fire.

Is there anything unusual about the BPC environment? 

I have noticed that the Workbook macro Open does not fire when the workbook is opened from the server for example.

regards

Ian

Tags:
replied

Hi Ian,

Your requirements are not 100% clear, but:

"I have noticed that the Workbook macro Open does not fire when the workbook is opened from the server for example."

Use AFTER_WORKBOOK_OPEN event (look help 42.7)

Vadim

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question