Of 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 MoreMost businesses are migrated or are in the process of migrating, critical workloads to cloud infrastructure. The competitive advantage cloud platforms give businesses makes this move an easy choice for organizations. Employees on the front lines tasked with managing these workloads know making the choice to move to the cloud is easier than performing the actual migration. Fortunately, PMsquare is here to help! I’ve created a high-level checklist to keep in mind when beginning your cloud migration. This list will help frame your thinking when planning to move on-premises applications to a cloud provider like AWS, Azure, or Google Cloud.
Read MoreOnce you have started honing your report authoring skills in Cognos Analytics, you may want to take the next step in your authoring… and customizing the output using Conditional Formatting is one of the ways you can do this. As implied by its name, Conditional Formatting allows the user to apply formatting only when a certain condition is met.
Read MoreIn this article, we are going to walk through the steps of setting up a function through AWS Lambda, connecting that function to a callable API with AWS API Gateway, and calling the API through a custom web application to build a simple web page that displays the various weapons and armors that can be found in Elden Ring.
Read MoreMany organizations struggle to figure out whether migrating to the cloud is the right financial decision. There are many questions that must be answered prior to making a final call. For example, what financial factors should be taken into consideration when deciding if your company should migrate to the cloud? How can you calculate the cost of running your operations in the cloud? What are the hidden costs associated with a cloud environment? How much will you be spending or saving every month by running your operations in the cloud instead of on-premise? The first step to answering any of the questions is to examine all costs associated with the current infrastructure.
Read MoreIncorta is a direct data platform that delivers an end-to-end self-service data experience. Incorta consolidates data management and analytics into a single integrated platform for data acquisition, storage, analysis, visualization, and reporting without the cost and complexity of traditional solutions.
Read MoreTo figure out which version of Cognos Analytics you’re on, you can simply use the UI to get an initial understanding. Click the Personal Menu in the top right, then choose About. To find out deeper information, you can use the cmplst.txt file in your install.
Read MoreKai Ming, a non-profit agency providing comprehensive early care and education services for underprivileged children, and PMsquare, a data analytics technology and consulting firm, are excited to announce that the PMsquare Children’s Center has officially opened its doors on May 13th in Mission Bay, San Francisco.
Read MoreInstalling Cognos takes time. The more complex the environment, the more time it takes. The time spent running the Cognos installer is compounded by the number of environments that need to be created. Fortunately, there are options on AWS to help Cognos administrators get out of the business of waiting for the install to complete. The two options we will be exploring here are EC2 user data and custom AMIs.
Read MoreIBM’s latest releases include a “new experience” cube viewer (or exploration) and a newly configured Set editor. There are several improvements and enhancements to the new viewer and set editor that represents IBM’s direction in making features easier to access. IBM is focused on improvements to the “new experience” within Workspace as it plans to deprecate the “classic experience”.
Read More
