Blog

Query calculations In Cognos

  • (4.0)
  • | 1492 Ratings

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:

Query Calculation 1Query Calculation 2Query Calculation 3Query Calculation 3Query Calculation 4Query Calculation 5

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

Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.


DMCA.com Protection Status

Close
Close