Cognos PowerPlay Transformer - Models and Cubes

PowerPlay Transformer is a Cognos component used to define OLAP cubes structure and data (in PowerPlay models) and build the multidimensional analysis cubes called PowerCubes.

A PowerCube contains calculated, summarized data organized into dimensions and measures and can be viewed and analysed in the PowerPlay Web Explorer, PowerPlay client for Windows, PowerPlay for Excel or Cognos 8 BI. PowerCubes provide secure and fast data access.

Keep in mind that Cognos cubes are static and building a PowerCube is a repetitive process (cubes may be refreshed every day, every month or even once a year).
The PowerCubes can be accessed and used both on-line (PowerPlay Web & Cognos 8) and off-line (PowerPlay Client).

Main PowerPlay Transformer features:

· Advanced modelling capabilities

· Leverages aggregate and fact tables

· Intergation of the query data into the model

· The models are defined by dimension structures and measures which can be easily customized

· No custom programming required

· Time periods are handled in a specific way which makes data delivery easy

· High flexibilty and portability.