Mindmajix

Enhancing query subject

ENHANCING QUERY SUBJECT:

  • 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

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

Screenshot_51

Screenshot_52

Screenshot_53

Screenshot_54

Screenshot_55

http://ibm.co/1Yh67g2

 

Enroll for LIVE, Instructor LED ONLINE COGNOS TRAINING


0 Responses on Enhancing query subject"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.