Is it possible to execute saved Macros (CAC 8.4.1) from Cognos Connection?
Yes, you can.
In your macro configuration you need to make sure you publish the macros to cognos connection. Then, in cognos administration in cognos connection you would navigate to Configuration > Content Administration > Planning > Macros. All the macros you've published will be present here. You can then execute and schedule the macros as you wish.
Hope this helps.
Eric - thank you, that worked out great!