Skip to main content

Data & Intelligence

IBM Cognos TM1 Server Environments and Model Migration

IBM Cognos TM1 employs a distributed, client-server architecture that consists of the IBM Cognos TM1 server to which a combination of different clients can connect. The TM1 Server manages access to the Cognos TM1 data directory for Cognos TM1 clients. The data directory is where files are migrated from and to and this “migration of files” requires a strategy.

The Components of a Migration

First, it is important to understand that all software migrations will include 4 general components. These are:

  • Identify,
  • Isolate,
  • Install and
  •  Insure.

migration

Identify

All development activity should be logged to easily identify the files that need to be migrated. Currently, Cognos TM1 does not support vigorous change management or source control automation. You should therefore consider a simple, manual method for documenting development such as using a “Change Log” file or listing.

Release Guide

In addition to file identification, it is recommend that a standard TM1 Server Software Release Guide be prepared for the migration. This release guide should be saved along with the staged migration (release) files.

Isolate

Once the files to be migrated are identified, they need to be isolated (from the source environment) and labeled with a software version identifier.

Software versioning is the process of assigning either unique version names or unique version numbers to unique states (or releases) of computer software. Within a given version number category (major, minor), these numbers are generally assigned in increasing order and correspond to new developments in the software. At a fine-grained level, revision control is often used for keeping track of incrementally different versions of electronic information, (different releases).

Isolation or Staging

Since it is assumed that development activities will continue (and may involve some of the files being migrated at this time), it is important to be able to audit isolated “versions” of each file that was migrated during a specific migration or release.

A best practice recommendation is to utilize a isolation or “staging” area. Typically this is a secured, backed up folder that is not located in the same location of the source TM1 server.

Install

Before you Begin

TM1 includes a collection of tools that provide logging and real-time performance monitoring of the TM1 servers in your environments. You can monitor TM1 performance and activity using these tools. It is a best practice recommendation to monitor and record these statistics on the target server before and after performing a migration. Careful statistical collection will provide:

  • The effect of the latest release on server performance
  • The effect of the latest release on application performance
  • Overall baselines for future development efforts and performance testing

Insure

 

Once a migration or release is completed, a validation needs to be done to insure that the migration was completed successfully and with the expected results.

Validation Types

There are 2 types of validations to be performed:

  • Validate that the destination server has not been ill-affected by the installation or migration performed
  • Validate that the installed or migrated files are behaving as expected

General Recommendations

The following are several additional recommendations that should be considered prior to performing a migration:

  1. Developers support but do not perform migrations
  2. Determine migration roles and responsibilities, obtain appropriate security access – usually administrator access to target environment and services
  3. Perform a migration plan review and walk-through
  4. Perform a migration post-Morten

Conclusion

The process of model migration can become very complicated. The above thoughts should be input to building your strategy based upon your individual requirements.

Good Luck!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Jim Miller

Mr. Miller is an IBM certified and accomplished Senior Project Leader and Application/System Architect-Developer with over 30 years of extensive applications and system design and development experience. His current role is National FPM Practice Leader. His experience includes BI, Web architecture & design, systems analysis, GUI design and testing, Database modeling and systems analysis, design, and development of Client/Server, Web and Mainframe applications and systems utilizing: Applix TM1 (including TM1 rules, TI, TM1Web and Planning Manager), dynaSight - ArcPlan, ASP, DHTML, XML, IIS, MS Visual Basic and VBA, Visual Studio, PERL, Websuite, MS SQL Server, ORACLE, SYBASE SQL Server, etc. His Responsibilities have included all aspects of Windows and SQL solution development and design including: analysis; GUI (and Web site) design; data modeling; table, screen/form and script development; SQL (and remote stored procedures and triggers) development and testing; test preparation and management and training of programming staff. Other experience includes development of ETL infrastructure such as data transfer automation between mainframe (DB2, Lawson, Great Plains, etc.) systems and client/server SQL server and Web based applications and integration of enterprise applications and data sources. In addition, Mr. Miller has acted as Internet Applications Development Manager responsible for the design, development, QA and delivery of multiple Web Sites including online trading applications, warehouse process control and scheduling systems and administrative and control applications. Mr. Miller also was responsible for the design, development and administration of a Web based financial reporting system for a 450 million dollar organization, reporting directly to the CFO and his executive team. Mr. Miller has also been responsible for managing and directing multiple resources in various management roles including project and team leader, lead developer and applications development director. Specialties Include: Cognos/TM1 Design and Development, Cognos Planning, IBM SPSS and Modeler, OLAP, Visual Basic, SQL Server, Forecasting and Planning; International Application Development, Business Intelligence, Project Development. IBM Certified Developer - Cognos TM1 (perfect score 100% on exam) IBM Certified Business Analyst - Cognos TM1

More from this Author

Follow Us