Home  >  Blog  >   IBM Cognos

Differences Between Macro & Prompt In Cognos

Rating: 5
  
 
6843

Macro:

A macro is a fragment of code that you can insert in the Select statement of a query or in an expression.

A macro may contain one or more macro functions. A macro is delimited by a number sign (#) at the beginning and at the end. Everything between the number signs is treated as a macro expression and is executed at run time.

  • Is a dynamic object which returns a value when executing a query
  • A macro can be placed in any part of the SQL statement

Learn how to use Cognos, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll for Free Cognos Training Demo!

Differences between macro & prompt

Macro- A macro is a set of instructions that can run applications. A macro is a dynamic object which is used to substitute the values at query run time.

Example : A macro can open your catalog,select a report(say for instance) convert that to another format and export it to any specified location,provided the code (Program)is such.

Prompt- A prompt specifies the manner in which data in the reports are to be displayed. A Prompt can be defined at the catalog level either or during report generation. Prompt is dynamic condition which select the value or enter the value at query run time  

  • A macro is a non user interactive object where as prompt is a user interactive object
  • The macro returns a single value, but a prompt can return multiple values

 MindMajix YouTube Channel

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
IBM Cognos TrainingMar 30 to Apr 14View Details
IBM Cognos TrainingApr 02 to Apr 17View Details
IBM Cognos TrainingApr 06 to Apr 21View Details
IBM Cognos TrainingApr 09 to Apr 24View Details
Last updated: 04 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read more
Recommended Courses

1 / 15