How to create, implement and use conditional blocks in Cognos reports.
Conditional blocks show different display results based on user interaction or parameters read in when a report is run. They provide a creative method for presenting either the same report data in various formats or executing several completely different reports from one prompt page. Read more
Employee compensation accounts for most of the expense base for service-oriented companies. The true ‘driver’ for this expense revolves around workforce planning. Creating a projection that matches the size of the workforce to the demands of the business can be a difficult exercise. Like most complex tasks, breaking it down into manageable components makes it easier to implement. This is the core principle behind driver-based compensation planning. Read more
There is a plethora of content available on utilizing the various TM1 functions, but what happens when these functions do not work as expected? What do you do when a rule does not return the expected value, a TI process does not load the values you had hoped for, or a cube’s performance is below acceptable levels? This article will cover some techniques for debugging TM1 that you can use to resolve issues with rules, TI processes, and cube performance. Read more
IBM estimates that most businesses utilize about 20% of the data they collect, with the other 80% of a company’s stored information remaining under-utilized or inaccessible.
Today, businesses are storing more data than ever before. Data is vital for record keeping and to provide competitive advantage through reporting and analysis tools. So why the low utilization? Read more
Earlier this year, we published a newsletter article scratching the surface of the Text Analytics Premium add-on for IBM SPSS Modeler. It introduced the fundamentals of text analytics and the idea of extracting information from unstructured text data. In this follow-up article, we will dive more deeply into some of the more advanced topics to fully leverage the add-on’s functionalities. Read more
As Business Intelligence (BI) systems become more and more embedded into the critical, analytics-based DNA of corporate decision-making, it is more important than ever to keep the system up and running at the highest level of efficiency. This article discusses methods for providing real-time monitoring and historical trending information for your system in the form of performance metrics. Read more
One question that Cognos Business Intelligence consultants often hear is “I bought licenses from IBM. How do I implement them in my user community and provide them with the various studios available in Cognos? There are so many studios, and I’m not sure which ones to give my users.”
The purpose of this article is to help your Cognos BI Administrator appropriately distribute user licenses and give access to licensed capabilities in IBM Cognos. There are four primary user license types: Enhanced Consumer, Advanced Business Author, Professional, and Administrator. One responsibility that generally lands on the IBM Cognos Administrator is to monitor the use of each purchased Cognos license. This is required to both maximize the utilization of the licenses and to make sure that the organization is in compliance with the IBM Cognos license agreement. The BI Professional role is for the technical developer/user who does not have administrative tasks. The BI Enhanced Consumer role is for consuming reports. Falling in between Enhanced Consumer and BI Professional is the Advanced Business Author, who has a need to both create and consume reports. Read more
Synopsis: How to create an external data file to use as a burst table for a Cognos report.
Pre-Requisites: This article assumes familiarity with how to burst a report and how to use external data, and creating an external data package. Read more
Over the years I have successfully used the ancestor(), parallelPeriods(), periodToDate(), aggregate(), and set() dimensional functions to develop robust and durable dimensional reporting solutions in IBM Cognos BI.
I had the opportunity to go to lunch the other day with one of my clients from a few years ago and they told me that the profit and loss reports that I wrote for them were still in use. These reports used no year or month members (directly) and required little if any maintenance over the last two years, despite daily refreshes of the source PowerCube. Read more
Python is a powerful open source general-purpose programming language. Through an easy-to-use structure, it allows users to perform a huge variety of controlling tasks on a computer.
In the case of using the Python plug-in for SPSS, it enables one to control the program flow based on conditions, to execute different syntax dynamically and interactively according to intermediate results, to apply command extensions and unlimited Python modules for more complicated algorithms, etc. Read more
Ironside is a data, analytics, and AI consulting and technology implementation company. We work with clients to understand their business objectives and day-to-day challenges, then employ our deep expertise in data strategy, architecture and engineering, integration, business intelligence, AI, and generative AI. We create technical solutions and practical approaches designed to drive smarter, data-driven decisions across a company and help it move further and faster toward its business goals.