Monday, August 24, 2009

Important Info For Migration of Cubes

Transformer
You can use IBM Cognos PowerCubes and Transformer models that were generated by Transformer 7.3 or later directly in IBM Cognos 8. The cubes and models are upwards compatible and require no migration or upgrade tools. You can run reports and analyses in IBM Cognos 8 against the IBM Cognos PowerCubes.
If you want to use the integration features of Transformer with IBM Cognos 8, you can upgrade
IBM Cognos Series 7.x Transformer models to IBM Cognos 8 BI Transformer 8.3 or higher. This
allows you to use IBM Cognos 8 data sources (such as published packages), list reports authored
in Query Studio or Report Studio, authenticate using IBM Cognos 8 security, and publish directly to IBM Cognos Connection.
If the model was secured in IBM Cognos Series 7 you must configure the IBM Cognos Series 7
namespace in IBM Cognos 8 before you load the model. The name ID that you use to configure
the namespace in IBM Cognos 8 must match the name used in IBM Cognos Series 7.
For more information about upgrading IBM Cognos Series 7 secured PowerCubes, see the IBM
Cognos 8 Transformer User Guide.
For IBM Cognos Series 7 PowerCubes to be used in IBM Cognos 8, we recommend that you
optimize the cubes for use in IBM Cognos 8 by using the pcoptimizer utility, which is supplied with IBM Cognos 8. Otherwise, PowerCubes that were created with previous versions of Transformer may take too long to open in the IBM Cognos 8 Web studios. This optimization utility is suitable for older PowerCubes when the model no longer exists or the data used to build the PowerCube is no longer available. It is not necessary to run this command line utility for cubes created in IBM Cognos 8 Transformer. For more information about optimizing PowerCubes, see the Transformer User Guide.

You can publish single PowerCube data sources and packages to IBM Cognos Connection interactively in Transformer or in the command line. You can also publish silently using batch scripts after building a PowerCube. A user who has privileges to create data sources and packages in IBM Cognos Connection can publish PowerCubes in IBM Cognos Connection as well. The MDC file must be in a secured location that the IBM Cognos 8 dispatcher can access. Packages that use multiple PowerCubes or PowerCubes mixed with other data sources should be published using Framework Manager.
If you use an IBM Cognos Series 7 PowerCube as a data source, IBM Cognos 8 converts the cube
data from the encoding that was used on the system where the PowerCube was created. For a successful conversion, IBM Cognos Series 7 PowerCubes must be created with a system locale set to match the data in the PowerCube.

No comments:

Post a Comment

Working with Compression on HDFS

Copy and uncompress file to HDFS without unziping the file on local filesystem If your file is in GB's then this command would cer...