Go to Top

Cognos Tips & Tricks

On Demand (recorded) Webinar – BusinessPLUS Webinar | See the combined power of BusinessPLUS with Cognos

Many BusinessPLUS customers have been asking for a way to more easily access and share information from HR, Payroll, GL, etc. Our partnership with IBM gives you access to the most powerful reporting and analytics tools available for a fraction of the retail cost. During this webinar, we review exactly how Cognos works with BusinessPLUS. Some of the highlights are: • Easily access data from BusinessPLUS to create reports and …Read More

Upcoming Live Webinar – Use IBM Cognos Event Studio to notify you about ANYTHING!

Use IBM Cognos Event Studio to notify you about ANYTHING! (Live Webinar)  Wed, August 30th, 2017 10:00 AM – 11:00 AM CST  With data coming in from every direction, sometimes the biggest challenge is knowing WHAT to pay attention to! You may have hundreds of reports, dashboards, etc. available but which one should you look at today? With IBM Cognos Event Studio, you can easily set up alerts to notify you …Read More

Upcoming Live Webinar – Expand Beyond Core for 360-View of Customer – We hope you are able to join us!

Expand Beyond Core for 360-View of Customers – Overcome Core Limitations with Cognos Analytics (Live Webinar) Wed, July 26, 2017 12:00 PM – 1:00 PM CST Across the banking industry analyst struggle to leverage existing reporting environments to examine customer behavior.  The right data analytic environment can provide vital insights into customer demographics and spending patterns by aggregating transactions and providing self-service capabilities to your front-line staff. Join this interactive webinar …Read More

Using an “If Then Else” Statement In a Filter

Another great Cognos Tech Tip from one of our expert consultants. Thanks Trevor for providing this one! You can use if then else statements in a filter as long as you have a static answer (or set of answers) to complete the filter logic, rather than using column names like you would in a calculation. The filter in the screenshot is for a report that will show students with less …Read More

SQL Tech Tip: UNION ALL vs. UNION?

When doing a union query, is it better to use UNION ALL versus UNION? The UNION will try and eliminate duplicate rows between the two queries and essentially does a select distinct on the entire query. Most of the time when doing a union, users build the queries so that each query returns unique results and therefore they don’t need UNION. So, if you have a slow union query, try …Read More

Prompt Basics in Cognos Report Studio – What type of prompt do I use?

Need to know what type of prompt to use?  In this 2-part tutorial video we describe the various prompt objects available for use within Cognos Report Studio.  We will introduce prompt basics as well as how to identify different types of prompts, each prompts function, the benefits and when and where to use each one.  In addition, the basic definitions of parameters, parametrized filters, and the  purpose of prompts are …Read More

Cognos Video Tech Tip

  Dynamic Columns in Cognos Check out our Youtube channel for Cognos tech tips put together by our Cognos rock stars! Today’s Tech Topic: How to create reports where you can select, based on a prompt, which columns you want to display in a list.  Great tip – check it out!        

Cognos Video Tech Tip: Alternate Row Formatting in Crosstab Reports

Cognos Video Tech Tip: Alternate Row Formatting in Crosstab Reports: An issue that comes up with multilevel crosstab reports is being able to tell where the data from one object ends and another begins in the crosstab intersection portion. It would be very beneficial if you can easily tell where one section of data ends and the other begins. This can be accomplished by using conditional styles in Cognos. In …Read More