IMPORTANT NOTE: We recently updated the Cognos interface and login steps. Please see the Key Changes to Cognos page to review these important changes.

Cognos Analytics

IBM Cognos Analytics is the primary tool used for reporting on data in the WashU data warehouse. Using the tools in the Cognos suite, you can author reports and analyze data to make the best decisions for your team.

Self-service analytics is an integral part of the overall Analytics solution we provide to our community. Providing access to all relevant data through packages allows building individual reports for a wide range of business issues.

If you experience a data mismatch, it may be due to a pending data refresh. View the Refresh Schedule

Cognos Packages

Reporting in Cognos is done out of pre-curated data queries called packages. These are your data sources in Cognos. In our former data warehouse, there was only one type of package (CQM); but in our new warehouse, there are two.

CQM (compatible query mode) Packages are the older type, developed in 32-bit C++ with limited query speed. These types of packages do not allow cross-package joins.

DQM (dynamic query mode) Packages are the newer type, developed in 64-bit Java and able to handle larger amounts of data. These types of packages allow cross-package joins, enabling multi-package and cross-domain reporting.

In Cognos you will now see both types of packages available to you, but the CQM packages are now read-only, meaning that you can still run reports from these packages, you just can’t create new reports based on them. All new reports should be authored from a DQM package.

It is also worth noting that new data generated in Workday will not show up in the older CQM packages.

So why did we leave the older CQM packages in place? To keep the baseline datasets in place so that data does not change and your existing reports will still run.

Cognos packages
In this image, the top package is the newer DQM package and the bottom package is the older CQM version of that package.
Cognos Training

Cognos training is recommended for all Cognos users, though the type of training you need will depend on whether you are a report author or report consumer.

Combining Legacy data with Workday data in Cognos

To accomplish a historical, or ‘year-over-year’ report after the Workday implementation, Legacy data will need to be combined with Workday data in Cognos. This will be possible when we roll out the Workday data source packages, and training over authoring these types of reports will be made available at that time. Stay tuned!

Accessing Cognos

To log into Cognos, see the new login procedures outlined on the Key Changes to Cognos page.

If you do not currently have access to Cognos, please see the Request Access page.