Add a query macro
Add a query macro to allow run-time changes
to be made to SQL queries.
About this task
When you reference a parameter, you must do the following:
- Use a number sign (#) at the beginning and end of each set of
one or more parameters.
Everything between the number signs is treated as a macro expression, which is processed at runtime. Framework Manager removes anything that is outside the number signs.
- Precede each parameter map entry with a dollar sign ($)
- Use a name that starts with an alpha character (a..z, A..Z)
Do not insert macros between existing quotation marks or square brackets because IBM® Cognos® Analytics - Reporting does not execute anything within these elements.