HI,
The DocOpen macro will run when you open a PPreport or cube. Depending on the name of the cube (linked to a random report) i want to do something.
My problem is that when the docopen macro is activated and i want to know the name of the cube I get an error.
When i execute this statement in the Macro:
I am receiving the Object Creation Failed error (429).
It seems logical because the Report hasn't opened yet (but i need the name of the cube). Is there a way to resolve this, in other words is there a way to resolve the name of the report/cube which is going to be opened. The afterdocopen macro is not an option, because this macro needs to have the same name as the report and it is not managed centrally. Thanks Steven Boon
The DocOpen macro will run when you open a PPreport or cube. Depending on the name of the cube (linked to a random report) i want to do something.
My problem is that when the docopen macro is activated and i want to know the name of the cube I get an error.
When i execute this statement in the Macro:
Code:
Set objPPRapport = GetObject(, "CognosPowerPlay.Report")It seems logical because the Report hasn't opened yet (but i need the name of the cube). Is there a way to resolve this, in other words is there a way to resolve the name of the report/cube which is going to be opened. The afterdocopen macro is not an option, because this macro needs to have the same name as the report and it is not managed centrally. Thanks Steven Boon