How to publish the Contributor Macro to Cognos Connection
1) In Contributor Admin Console (CAC), check the box "Publish to Cognos Connection" when creating the Macro. If the box was not checked when creating the Macro, edit the Macro and check the box and then click"OK". This causes the Macro to be accessible in Cognos Connection.
2) Open Cognos Connection as planning administrator or system administrator, select 'Tools'-> Content Administration.
3) Click the 'Planning' folder and then the 'Macros' folder and you shall see the Macro that was published from CAC
4) Click the Schedule Icon and you will be able to set the schedule of running this Macro.