Crosstabs: Beyond the Basics
Crosstabs: Beyond the Basics

The goal of this article is to help readers gain a better understanding of working with crosstabs and expose some features and capabilities that newer users may not be aware of. Delve into the realm of advanced techniques for developing Crosstabs in Cognos Analytics with this article and unveil the potential of Crosstabs beyond basic reports, this article illuminates their pivotal role in complex report layouts. This article uncovers lesser-known features and capabilities, enhancing comprehension and utilization of Crosstabs in Cognos Analytics reporting.

Read More
Cognos AnalyticsMark KarasCrosstabs, Intermediate, Advanced Comment
PMsquare’s Quantum Leap: Expanding through Cloud Services Acquisition
PMsquare’s Quantum Leap: Expanding through Cloud Services Acquisition

PMsquare acquires Quantum Leap Innovation as part of their continued investment into the cloud consulting space. Along with the acquisition comes the addition of a new member to the PMsquare leadership team, Sanjeev Pant. By uniting data analytics with cloud services, PMsquare is well-positioned to redefine the landscape of technology solutions for enterprises globally.

Read More
Company NewsDustin AdkisonThe Cloud, Acquisitions Comment
The Ultimate Guide to IBM Cognos Installs and Upgrades
The Ultimate Guide to IBM Cognos Installs and Upgrades

Once upon a time, new releases of Cognos Analytics (at the time known as Cognos BI) only came around once a year or so. This was how the software industry as a whole used to operate—but these days things are different. More frequent, smaller releases are the name of the game, and with the more rapid release cadence comes a more persistent urge to install new Cognos Analytics software versions, delivering powerful new features and critical bug fixes to end users in an expedient manner.

Read More
Cognos AnalyticsPMsquare Cognos Analytics Consulting TeamCognos, cognos maintenance Comment
Cognos Analytics 12 Parameters Page
Cognos Analytics 12 Parameters Page

In Reporting, prior to Cognos 11 versions, it was difficult to change anything related to the parameter without deleting and recreating one.  Then in Cognos 11 versions we got the ability to swap parameters for a prompt and rename them and such.  Now, with the release of Cognos 12, we have a dedicated page where we can create all the parameters we need beforehand without creating prompts first. There is a wide variety of impressive things you can do with the parameters now, with the addition of a new Parameters Page in Report Authoring, so let’s take a look at what has been added.

Read More
Cognos AnalyticsDanny Garguscognos reporting, Cognos, Cognos Parameters, Cognos 12Comment
Best Practices to Avoid Bottlenecks in AWS Glue and Redshift
Best Practices to Avoid Bottlenecks in AWS Glue and Redshift

AWS Glue is a server-less data integration service that provides all capabilities needed to categorize, clean, enrich and move the data between data stores. It is a powerful ETL tool that reduces and automates a significant portion of the effort required for data integration. To fully leverage AWS Glue’s capabilities for production workloads, the service must be fine-tuned with proper configurations to reduce job runtime and increase resource availability.

Read More
Amazon Web Services (AWS)Andreea StanoviciAWS, Glue, Redshift, Best PracticesComment
Yes, You Can Start Writing Expressions in Cognos!
Yes, You Can Start Writing Expressions in Cognos!

While reporting has evolved over the years and it is now possible to jump right into creating content in Cognos Reporting with drag-and-drop elements, becoming a true "Power User" requires a bit more know-how. It is critical to be comfortable writing expressions. That's where the Expression Definition box comes in. Whether you're just getting started or looking to expand your knowledge, this post will show you that there's no need to be intimidated by expressions. So, let's dive in and take a closer look at this powerful tool!

Read More
Cognos AnalyticsRayyaan SimonsCognos Expressions, cognos reporting, AnalyticsComment
Data Visualizations in Planning Analytics
Data Visualizations in Planning Analytics

Data visualization has become an increasingly important tool in today's data-driven world. By converting complex data sets into visual representations, we can quickly identify patterns, trends, and insights that would be otherwise difficult or impossible to detect. IBM Planning Analytics Workspace, or PAW, is designed to offer a user-friendly and intuitive interface that makes it easy for users to create data visualizations. In this article, we will explore how one can use different visualization types, the layout of a workbook, and different property settings in PAW to create an appealing design that truly stands out from the rest, capturing the attention of the audience and effectively conveying important insights from the data.

Read More
Planning AnalyticsWerner CoetseePlanning Analytics Workspace, IBM Planning AnalyticsComment
How to Burst in Cognos Analytics Reports - A Short Explanation
How to Burst in Cognos Analytics Reports - A Short Explanation

In this article, we will discuss the basics of bursting in Cognos Analytics Reports. After reading this article, you will understand what the burst feature is, how to enable bursting and how to set up parameters, what the content of the report will look like, and how to test run the report. An example report is run for a group of hospitals to show how the bursting operation splits the data so that every hospital only receives the data applicable to it.

Read More
Cognos AnalyticsAdriaan BootBursting in Cognos, Cognos Reporting, Cognos Comments
Cognos Analytics - Multi-Select Prompts
Cognos Analytics - Multi-Select Prompts

One of the most important features of Cognos is the ability to create interactive reports that provide valuable insights to decision-makers.  One of the key components of creating these reports is the use of prompts, which allow users to filter and select the data they want to see.  In this article, we will focus on one specific attribute of the prompt, the multi-select property, which enables users to select or input multiple values at once.

Read More
Cognos AnalyticsDanny GargusCognos, Multi-Select PromptsComment
What's New in Planning Analytics?
What's New in Planning Analytics?

We’re discussing some of the new features and enhancements from the last few releases of Planning Analytics Workspace. We will dive into several topics ranging from changes to Dimension Editor, enhancements to building a book, to the all-new TI Process Debugger. The last few releases might not have been as hyped up as some releases of PAW in the past, but there are certainly some changes to make note of. Whether you're a seasoned user or new to Planning Analytics Workspace, these updates are worth checking out!

Read More
Planning AnalyticsKyle McIvorPlanning Analytics Workspace, IBM Planning Analytics, New Features, Dimension Editor, PAW Books, TI Process DebuggerComment
Using IBM Planning Analytics for Consolidations
Using IBM Planning Analytics for Consolidations

Existing customers of IBM Planning Analytics are likely performing consolidations of some sort, and oftentimes using different software systems to do so. These organizations come to realize that by layering the consolidation processes into their Planning Analytics system, they can save by not having to license and maintain multiple systems, train personnel on different products, and address technical issues with compatibility. This article will cover the many benefits of using Planning Analytics, or PA, to perform consolidations.

Read More
Planning AnalyticsBrian MoorePA Consolidations, IBM Planning AnalyticsComment
Unleashing the Potential of ChatGPT in Data and Analytics
Unleashing the Potential of ChatGPT in Data and Analytics

Data and analytics have undergone a profound transformation in recent years. The massive growth of cloud computing, big data and the proliferation of cutting-edge analytics tools have unlocked previously unattainable insights into complex business processes. However, as the data landscape continues to evolve, staying ahead of the curve has become a challenge for even the most seasoned data professionals. Enter ChatGPT and other advanced language model technologies - poised to revolutionize the way data and analytics are performed by providing a new level of automation, accuracy, and efficiency. Get ready to be blown away as you discover how ChatGPT is set to transform the world of data and analytics.

Read More
Artificial IntelligenceMike DeGeusData and Analytics, ChatGPTComment
Critical Vulnerabilities Addressed with Cognos Analytics 11.2.4 and 11.1.7 FP6
Critical Vulnerabilities Addressed with Cognos Analytics 11.2.4 and 11.1.7 FP6

Hey. Remember the Apache Log4j vulnerabilities that had us scrambling last holiday season? Well…we’ve got some new vulnerabilities this holiday season that we should each assess in terms of potential risk to our organizations. Probably not as pervasive as the Log4j issues of old, but certainly worth evaluating. As is often the case, the vulnerabilities are mostly exploited via third party components used by IBM Cognos Analytics. Here are a few of the higher CVSS base score issues on IBM’s radar that were addressed with base 11.2.4 and Fix Pack 6 for 11.1.7…

Read More
Cognos AnalyticsCraig ColangeloCognos, Upgrade, CogboxComment