When creating multidimensional models with IBM Cognos Transformer, many different types of data sources can be utilized such as reports, packages, Excel, and comma delimited files to design the model. Also various work environments may be used such as TEST, DEV, and PROD all of which have different server locations. Read more
At first glance, IBM Cognos TM1 and Cognos Planning have similar features. They both leverage a multicube architecture and support complex, cross-cube calculations.
The primary differentiating feature of IBM Cognos TM1 can be found in its efficient calculation engine and its method for storing data. When users enter data into most other planning applications, a read/write procedure is performed to reflect the change in a database stored on a hard disk. In contrast, IBM Cognos TM1 calculations and data storage happens in memory/RAM. This allows entered data to be immediately updated within the cube and retrieved. As a result, data is available real-time, which greatly enhances both the performance of queries and ability to perform what-if analytics. Read more
Many are looking to IBM Puredata System for Analytics (Netezza) but are unsure of the complexity of implementation. Is it a lift and shift? Is there redevelopment involved? The focus of this article is to describe the process for migrating from Oracle. At a high level this process is the same when migrating from other RDBMS but every RDBMS has its own nuances that should be taken into consideration. Read more
On February 18th, 2014, Ironside hosted a Cognos Dynamic Cubes webinar to introduce the capabilities of this new, powerful tool. Led by Ironside’s Michael Vollmer, Senior BI consultant, and Francois Ross, Regional Vice President, we gave attendees insights into how dynamic cube interfaces empower end users to access data at much faster speeds. 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
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.