This training session will focus on understanding the basics of SQL statements and how Cognos generates these SQL statement to pull data into reports.

We will investigate how Cognos SQL is generated from queries and how the performance of these queries can be improved to produce faster running reports. We will focus on how to create optimal queries by illustrating how filters, aggregation, functions, and joins effect the way Cognos generates SQL to pull from the CIW. In addition, we will also looks at query and report settings that can be utilized to improve performance for your consumers. Finally, we will use this knowledge to investigate how we can troubleshoot slow running reports and use the information above to improve the performance of existing reports.

Potential agenda included in Word document.  

November 21, 2019 1800 Grant St RM-100 1-3PM

Virtual Meeting information will be sent out at a later date to those intersted

If you would like to reserve a spot in the training, please email Aron at aron.sage@cu.edu

 Thank you! 

Aron Sage

Business Intelligence Analyst

University Information Services

University of Colorado

1800 Grant Street, Suite 317A

Denver, CO 80203

t 303 860 6216

aron.sage@cu.edu