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 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 MoreCognos version 11.2.3 brings several new features, but one of the most requested is the ability to have cascaded filters in Dashboards. The functionality is similar to the way you used cascading prompts in Reports, which have been around forever. When Dashboards came out, the filtering options were pretty limited. This addition sets the filtering up to be more interactive. Let's take a closer look.
Read MoreWhether you’re a small business or a large enterprise, when it comes to planning for your organization’s success in an unpredictable world that is data-driven, chances are that you have outgrown Excel spreadsheets and are looking for an extended planning and analysis (xP&A) software solution such as IBM Planning Analytics with Watson, Anaplan or Workday Adaptive Planning. Let’s have a closer look at some of the key features in IBM Planning Analytics with Watson, Anaplan, and Workday Adaptive Planning.
Read MoreMany companies have shifted to the public cloud in favor of rapid scaling, lower costs, availability, disaster recovery, and increased security. For those planning to migrate, AWS has identified three different primary phases associated with the migration process: assess, mobilize, and migrate/modernize.
Read MorePsst! Hey you…yeah…the one with the large Cognos Query Studio and Analysis Studio footprint. You know those studios have been around since 2005, right? Those were the Cognos 8 days! We know that there are still plenty of shops with Query Studio and/or Analysis Studio artifacts in use…but times, they are a changin’.
Read MoreThis is a continuation of the QuickSight series of posts, focusing on AWS QuickSight’s new feature, Q. Q is a machine learning powered querying capability in QuickSight that allows business users to query using their everyday natural language. Q is a way for organizations to break from the traditional BI mold. Previously, organizations needed a BI analyst or engineer to build out their dashboards.
Read MoreWith all the talk about cloud computing these days, does it really make sense to move your Cognos Analytics instance to the cloud? What functionality and benefits are gained or lost when doing so? What about when starting from scratch? What is the best option for your Cognos Analytics (CA) environment? There is no one-size-fits-all when it comes down to it. We’ll discuss the differences which, hopefully, will help you make an informed decision.
Read MoreThe average policy renewal time at New Mexico Mutual used to be 20 minutes. With RPA, it’s five minutes. A subprocess like policy assignment that used to require a minute of someone’s time is now completed in ten seconds or less by the RPA bot. Across a full workday at New Mexico Mutual, these improvements give three and a half hours back to staff. Moving forward, New Mexico Mutual isn’t limiting RPA to policy renewals. “We have also built two additional RPA bots for our claims department and one to assist in business analytics,” says De Bruijn. And the rest of the business has noticed. “In 2022 we’ve already gotten a lot of requests from our business teams. So we are going to continue that growth and automation.”
Read MoreToday, I’m going to show you how to use custom transformations in AWS Glue Studio! This will help smooth out the bumps of AWS Glue Studio by using custom coding – with Python!
Read MoreRoutine Cognos server maintenance is critical in order to ensure your environment performs optimally and remains reliable. Failure to attend to this could likely cause unnecessary downtime and impact critical deadlines. Similar to maintaining a vintage car – all it requires is some shrewd TLC. In this article, I review some key checks to assist in maintaining your Cognos Analytics servers.
Read More
