IBM Cognos Review
Automating Cube Build and Deployment on Windows Environment.

Valuable Features:

There are several valuable features of Cognos. In this review, I will be concentrate more on the Automating Cube Building and Deployment without any manual intervention.. even while a user is using a cube for reporting,  there will not be a situation as ' Cube file locked; unable to build or deploy'.

Improvements to My Organization:

IBM Cognos Transformer cubes are one of the widely used OLAP data sources. Normally, a PowerCube contains calculated and aggregated data that is organized as dimensions and measures, which can be viewed and analyzed in Analysis Studio and Report Studio (versions 10). Users find it easy to use and quick to access aggregated summary data which help in better analysis. IBM Cognos PowerCube data is static, and building a PowerCube naturally becomes a repetitive process. At my work place, cube data is refreshed on a daily, weekly, and monthly basis. Since the data volume and the number of dimensions and measures in the cube are big, the build process takes 3-4 hours to complete. In order to ensure the most benefit from the cube, having a scheduled and automated cube build is essential.

Deployment and Activation a new feature which was introduced in version 8.4 that allows the cube file to be automatically copied over to a specified local or network location, activated and/or archived depending on the requirements.

Basically one needs to set the Deploy properties on the .mdl file using Transformer.

Deployment Strategy: select the “Copy to available locations, then activate” option. This will copy the cube .mdc file to target server location.

After building the cube: select “Automatically copy and active”.

Deployment location: add a path for production and/or a place that .mdc file should be deployed too. You can select multiple locations. For instance, the same cube may be deployed to both the Development and Production servers.

– Check “Enable automatic PowerCubes deletion”

Once the changes are made, we need to use the Cognos Transformer command line is capable of performing certain modeling and cube-building tasks on the Windows, UNIX or Linux platforms. 

The general syntax for using windows command line is as follows:

cogtr -n -lcognostr10=/ -g -m" < cube .mdl path>

Notice that after the cube build completes, Transformer automatically deploys and activates the newly generated cube. It doesn’t require any changes to the data source connection. The live cube swap is effective immediately.

Just a few more steps (on Windows environment), you can now schedule the cube build via a job scheduler application, such as Windows Scheduled Tasks. Here once the ETL process is complete, a Flag file would be sent to Transformer box to trigger the cube builds. You will not need to manually rebuild or deploy the cube any more as everything will be done automatically on schedule.

Room for Improvement:

- Need improvement towards Visualization.

Use of Solution:

I've used Cognos in some form or the other past 10+ years

Deployment Issues:

Yes, since we were implementing VB Script batch file process on the Transformer server. We had to do some testing to ensure success. Later worked like a charm.

Stability Issues:

Cognos is extremely stable... Unless someone develops and tries to run a huge data set.. Its all about educating users.

Scalability Issues:


Customer Service:

Customer Service is good and quick answering.

Technical Support:

Yes, Technical Support is very good to some extent.. They would try the initial knowledgebase solutions ( which we would have already tried) .. but they do work along with us to solve issues... sometimes it is quick, some time it takes time reproducing the issue and solving..

Previous Solutions:

Always been using different versions of Cognos - right from the Impromptu.

Initial Setup:

It was a mix of both.

Implementation Team:

In-house. I have implemented most of the solution specific to user requirements.. One of them is the automate cube build and deployment.

Disclosure: I am a real user, and this review is based on my own experience and opinions.


Anonymous avatar x30

Have A Question About IBM Cognos?

Our experts can help. 218,478 professionals have used our research on 5,616 solutions.
Why do you like it?

Sign Up with Email