Blog

Create a macro to modify multi-lingual column names dynamically In Cognos

Create a macro to modify multi-lingual column names dynamically : (Know definition of MACRO, for a clear understanding).

Enroll for Instructor Led Cognos Report Studio Training
  • From MODEL
  • Expand the SALES namespace
  • Select the Query subject return_reason
  • Right click
  • Click on Edit definition
  • Delete the default SQL query from SQL pane
  • Expand Gosl
  • From available database objects pane
  • Select table returns_reason
  • Select the following query items
  • Return_reason_code
  • Return_description_fr
  • Drop on SQL pane
  • From Query
  • Delete fr
  • Click on insert macro
  • Expand parameter maps
  • Double click on localemap
  • Using last arrow key
  • Place the cursor between braces
  • Expand session parameters
  • Double click on run locale
  • Delete space between } and #
  • Click on OK
  • Click on Test tab
  • Click on Test sample
  • Click on OK

HTTP://IBM.CO/1S6AB3S

Frequently Asked Cognos Interview Questions & Answers


RELATED COURSES

Get Updates on Tech posts, Interview & Certification questions and training schedules