Blog

Query calculations In Cognos

Insert a query calculation into your report to add a new row or column with values that are based on a calculation. It is used to perform Data Scrubbing. 

  • You can create calculations to provide your users with calculated values that they regularly usel
  • Calculations can use query items, parameters, variables, calculated members, expressions, and expression components, such as functions
  • It allows you to create expressions to derive the new data definitions
Learn how to use Cognos, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll for Free Cognos Training Demo!

Procedure:

  • Add the following query items to the list report
  • Product line, order method, quantity, revenue
  • Group on product line , total on quantity, revenue
  • From tool box drag the query calculation
  • Drop beside the revenue item
  • Enter the name as sales tax
  • Click on OK
  • Develop the following definition
  • Revenue * 0.5
  • From toolbar click on validate
  • Click on OK

Frequently Asked Cognos Interview Questions & Answers

Query Calculations:

Explore Cognos Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

RELATED COURSES

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