,

Why Migrate from IBM Cognos Planning to TM1?

/by

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

,

Migrating from Oracle to Netezza

/by

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

,

Ironside Webinar Series: Overview of IBM Cognos Dynamic Cubes

/by

Dynamic CubesOn 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

,

Enhanced Security in IBM Cognos BI 10.2.1 Dynamic Cubes

/by

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

,

IBM Cognos Dynamic Cubes for Existing PowerPlay Customers

/by

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

,

Ironside Tech Tip: Working with IBM Cognos BI and Microsoft Office

/by

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.

Cognos Connection

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

,

Ironside Tech Tip: Capture Social Media Sentiment as It Happens

/by

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

,

Ironside Webinar Series: IBM Cognos Express Overview

/by

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

,

Ironside Tech Tip: Allow or Deny Access to a Report Based on the Time of Day

/by

clock graphicSecurity 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

,

IBM SPSS Statistics and R: Linkage and Usage

/by

Utilize IBM SPSS Statistics and R to Produce a Combination Correlation Table and Graphs

IBM SPSS Statistics is very powerful software that allows complex data analyses to be performed. R is a very useful software environment that provides a coding language tailored to statistical operations. This article will give an outline of the procedure to enable the use of SPSS Statistics and R to add even more functionality to the use of SPSS Statistics. The example that will be used is generation of a combination correlation table and various graphs using this integration. Read more