In Cognos, a macro is a set of instructions or commands that can run applications or automate tasks, while a prompt specifies the manner in which data is displayed in reports (such as filters, sorting, or formatting options). Macros execute actions; prompts control presentation.