Since TM1 is a memory-based OLAP engine, one of the most important considerations in developing efficient planning models is to utilize the least amount of memory that is available on the server. As time goes on the model will likely grow in size and consume more resources. This usually happens when you add additional elements the cube’s dimensions and archive fewer elements . As the cube reaches its memory limit, users may experience issues like poor application performance, longer server start times, crashes, and other similar problems. Also, adding new elements can multiply memory use further because rules may act upon the elements added and take up even more of the server’s available resources. Read more
While working as a Compensation Administrator, I used IBM Cognos ICM, a sales performance management software solution, to empower account executives to understand their compensation plan quickly, so they could get back to selling. The visualizations and rankings available in IBM Cognos ICM are excellent sales enablement tools for motivating individuals at all levels of a business. When leveraged correctly, these resources allow territory and channel managers to speed the production and delivery of scorecards and other reporting deliverables, leading to faster, more strategic decision making. Read more
Whether you are a Compensation Administrator, Account Executive, or Sales Manager, the process of paying people commissions and tracking their performance can be frustrating. I spent several years as an Administrator and worked with sales people, sales operations team members, executives, and many others. The following are the top 5 incentive compensation management pain points that I have discovered during those interactions: Read more
The IBM Cognos BI 10.2.1 release made significant enhancements to the Dynamic Cube options available in the product. One major boost to functionality is that you can now add enhanced security within Cube Designer and not have to restart the Dynamic Cube, and there are many other similar benefits included as well. Read more
You may have heard about the new Dynamic Cubes feature available in IBM Cognos. New technology is great, but if you have a library of existing PowerPlay cubes in your environment, you need to decide if it makes sense to migrate these cubes to Dynamic Cubes. Where does this new technology fit in your environment? What should you use to develop new cube capabilities if you choose to pursue them? This article will lay out the pros and cons of each approach in use case form to help you decide how best to leverage Cognos in your organization. Read more
The Next Step towards Predictive Maintenance Excellence
IBM Predictive Maintenance and Quality (PMQ) reduces operational costs, improves asset productivity, and increases process efficiency. IBM PMQ helps monitor, maintain, and optimize assets for better utilization and performance, by predicting asset failure and enhancing product quality and supply chain processes. Read more
Using Cognos we can generate reports in Excel, Microsoft Word and Power Point. In this article we will see what components we need to produce these reports in Microsoft Office.
Required Components and Installations:
1. You need to have Cognos environment ready and useable for generating reports, as shown below.
2. You have to install Microsoft Office in all the destination systems or client machines where we are going to access Cognos reports using Microsoft Office components. Read more
Use the SPSS Modeler Text Analytics Add-On to Monitor Social Media
As channels of social media penetrate people’s daily life more extensively and intensively, bad reviews and negative opinions travel faster than ever before. Research and surveys have shown that people are far more likely to spread the word about bad experience than a favorable one . Social media, by providing numerous opportunities for word-spreading, escalates this process. It is in the best interest of businesses to monitor comments on social media in real time. Read more
Midsized companies and certain departments within larger companies alike have long struggled to find a business analytics solution that really works. Many companies have used a mix of spreadsheets, databases, standalone tools, and inadequate software to meet their BI needs. These methods are often outdated, inefficient, and unable to deliver desired results. IBM Cognos Express helps address these challenges. Read more
Security in Cognos is extremely robust, permitting or denying very precise access to data elements in a package, data source, or even to row level access in a database. Read & Execute permissions are usually applied to a report allowing certain Groups or Roles the ability to run a report. However, you can also allow or deny access to a report to only let it execute within specific hours of the day. 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.