Cognos Tutorial: How to Add a Second Line Per Record for Long Fields Using Grouping and Footers

We’re excited to add an educational component to our blog! Our consultants are great informational resources, and we want to share their knowledge with you, our subscribers. We’ll update our blog regularly with various educational posts written by our Business Intelligence team. We hope you find them to be informative …

What’s New in Cognos 11! Attention eSchoolPLUS and eFinancePLUS Users!

What’s New in Cognos 11! Attention eSchoolPLUS and eFinancePLUS Users! Monday, October 30, 2017 12:00 – 1:00 pm CDT Come see what’s new in Cognos 11 and why you should upgrade sooner rather than later. There are many exciting differences. To name a few… • Redesigned and modern user interface…

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 …

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 …

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 …

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 …

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 …

Ever wondered what browsers, data sources, etc. IBM Cognos supports?

Here’s an easy way to find out! IBM websites move around so start by googling “IBM Cognos Supported Environments”. The first set of links should be correct but make sure they look similar to the below. Click one of the links and you should be taken to the following page …

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 …

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!…