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.
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 (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 (http://ibmcognosrmug.files.wordpress.com/2011/01/promptmacrormcognosusergroup.pdf) for examples
Thanks