Macros and memory consumption

[pkrishnaq]

Greetings Cognos brothers,
Do Macros in Cognos consume a lot of memory? I have couple of macros defined in the framework manager and it is taking an awful long time to run the reports.

Is anyone aware of macros and their memory consumption?

Thanks in advance ;D

[cognostechie]

That depends on the macro. Ex: If it is a macro that simply provides a value in the filter then it will not consume any additional memory as compares to hard coding the value in the filter. Macros is Cognos basically re-write the SQL before the SQL is sent to the DB so in most cases, they should not consume more memory and actually they can improve performance in some cases.