The Planning Analytics (TM1) function LogOutput has been around since TM1 version 10.2. This function allows developers to write custom messages to the tm1server.log file when a certain condition occurs in your TurboIntegrator (TI) Process. Let’s explore the functionality and usage of the LogOutput function.
Read MoreThe "Glass" interface in Cognos is extremely flexible, and with a bit of effort can modify Cognos to the point it becomes unrecognizable - the customization potential is truly unlimited.
Read MoreOnce 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 MoreIn 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 MoreAWS 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 MoreData Servers in Cognos Analytics offer significant advantages over traditional Data Sources when it comes to setting up connections to physical databases or other data sources. Let's take a look at how they compare to Data Source connections, how you set them up, and what makes them more useful than a standard Data Source Connection.
Read MoreWhile 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 MoreAlrighty…let’s finish this blog series off with a nice win! The Progress DataDirect Autonomous REST connector included with Cognos Analytics 11.2.2 has been improved by Progress and we can now effectively use it to do some straightforward querying of the U.S. Considering how easy it is, why not give it a shot?
Read MoreData 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 MoreIn 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 MoreOne 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 MoreWe’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 MoreExisting 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 MoreData 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 MoreIt’s Valentine’s Day! What better way to celebrate, than to look at the significant changes that the world of love and relationships has undergone in recent years through the lens of technology and data. Let’s take a look at a few key insights.
Read MoreYou have probably heard the term “SQL,” and may even know what it is used for, but if you don’t know how to write or use it, or simply aren’t using it, this article will help you start your journey into learning SQL (Structured Query Language).
Read MoreAWS recently released integrated version control for Glue using either GitHub or AWS CodeCommit. This allows Glue jobs to be versioned in a central repository for easy rollback and recovery. Let’s look at the set-up process and then check out the versioning in action.
Read MoreHey. 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 MoreOf the various data containers in Cognos, Crosstabs offers the most flexibility. With the flexibility comes a great deal of complication. From a simple two-dimensional layout to complicated multilevel nesting with subtotals and fancy formatting - the limit is really down to your imagination.
Read MoreWithin most Cognos report objects there are numerous property settings that allow customization to match precise report requirements. It’s even possible to fine-tune aggregations to work in a specified order. With all these properties however, Cognos does not have native functionality to add tooltips (with the notable exception of inside visualizations).
Read More
