Blog

  • Home
  • Cognos
  • How to Create a Macro To Filter Multilingual Rows In Cognos

How to Create a Macro To Filter Multilingual Rows In Cognos

  • (4.0)
  • | 676 Ratings

You can go through create a macro to modify multilingual columns before learning how to create a macro to filter multilingual rows.

Enroll for Instructor Led IBM Cognos Training

Steps to Create A Macro in Cognos To Filter Multilingual Rows

  • From SALES namespace
  • Select country_multilingual query subject
  • Click on Edit definition
  • From SQL pane
  • Delete default SQL Query
  • Expand gosl
  • Select country_multilingual
  • Select all query items
  • Drop on SQL pane
  • Define the where clause with the following syntax
  • Where country_multilingual“language”=insert macro
  • From toolbar
  • Click on single quote button
  • Click on test tab
  • Click on test sample
  • Click on OK

HTTP://IBM.CO/1RIZTV5

 

Frequently Asked Cognos Interview Questions & Answers