Query calculations In Cognos

• (4.0)

• | 1913 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

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:

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.