i am trying to call a macro on the drill through in the model...
The reason for me calling a macro here and not actually specifying the cubes in the drill through of the model is ... i have department dimension in the model with the department id's level - when user is viewing the cube depending upon the department selected - when the user clicks the (+)drill through icon on the cube - within the macro i am trapping which department is filtered and accordingly open the drill through cube of the respective department ..
The model has properly generated the categories and cube after me specifying the macro in the drill through - but when i click the drill through icon while viewing the cube - i get the following error:
"PowerPlay is unable to successfully run the macro.Try compiling and debugging the macro in the CognosScript Macro Editor"
any way i can get this to work ...
TIA
mid181
The reason for me calling a macro here and not actually specifying the cubes in the drill through of the model is ... i have department dimension in the model with the department id's level - when user is viewing the cube depending upon the department selected - when the user clicks the (+)drill through icon on the cube - within the macro i am trapping which department is filtered and accordingly open the drill through cube of the respective department ..
The model has properly generated the categories and cube after me specifying the macro in the drill through - but when i click the drill through icon while viewing the cube - i get the following error:
"PowerPlay is unable to successfully run the macro.Try compiling and debugging the macro in the CognosScript Macro Editor"
any way i can get this to work ...
TIA
mid181