Macros in Report Studio

[yogeswari]

Can anyone tell about the usage of MACRO in report studio.

What is the usage of macro and how it is used in report studio level.

Why we need macros??
Explain with example is highly appreciated.

Thanks,
Yogeswari.

[Ganesh Kedari]

Hi Yogeswari,
macros are a functions or Texts  which replaces a value at Run time . This is similar to macro concept used in Programming.
macros are identified by # in expression.

Example : [gosales].[Sales staff].[Staff name] = #$UserLookUpMap{$UserId}#

You can refer Chapter 18 from IBM Cognos Report Studio Version 10.2.0: User Guide http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.0/ug_cr_rptstd.pdf

You can also refer http://ibmcognosrmug.files.wordpress.com/2011/01/promptmacrormcognosusergroup.pdf for examples


Thanks