Blog

  • Home
  • Cognos
  • Enhancing query subject in Cognos Framework Manager

Enhancing query subject in Cognos Framework Manager

  • (4.0)
  • | 809 Ratings |
  • Last Updated February 15, 2017
  • 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


Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.


DMCA.com Protection Status