How to Create a Macro To Filter Multilingual Rows In Cognos

  • (4.0)
  •   |   553 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



Frequently Asked Cognos Interview Questions & Answers

Popular Courses in 2018

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