Blog

Enhancing query subject in Cognos

  • A query subject can be enhanced with a new query item by modifying the SQL
  • The query subject definition can be viewed in the form of an SQL Query
Enroll for LIVE, Instructor LED ONLINE COGNOS TRAINING

Procedure:

  • In the previous viewer pane
  • Expand the MODEL
  • Expand the SALES namespace
  • Select the query subject order_details
  • Right Click
  • Click on edit definition
  • From SQL pane remove the default SQL select statement
  • From available database objects pane
  • Expand gosl
  • Expand the tables
  • Select the table order_details with all columns
  • Drag and drop on the SQL pane
  • Add the following query items to the SQL query
  • Order_details.quantity*order_details.unit_price as planned revenue
  • Order_details.quantity*order_details.unit_sale_price as actual revenue
  • Select the test tab
  • Click on test sample
  • Click on OK

HTTP://IBM.CO/1YH67G2

Frequently Asked Cognos Interview Questions & Answers


RELATED COURSES

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