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
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
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
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
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 where you can select the version of IBM Cognos you are interested in. You’ll see below the version that you …Read More
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
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: 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
Cognos Tech Tip: Punch up your Cognos. Our experts provided this tip on how to keep totals and footers from breaking onto a separate page. 1. Go to Properties on a list 2. Select Pagination 3. Locate the Keep with Footer field. Ta da, the number you enter in the field is the minimum number of rows that will be kept on the page with the footer.
Cognos Queries Sometimes people want to see every day in a month even if there aren’t records. For instance show me the entire month and the number of marketing transactions that happened per day (even if there weren’t any). If there is no data for a day then you won’t have that day in your results. One way to get around that is to have a query that returns every …Read More