PowerPlay Transformer application

The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Building a PowerPlay model involves designating columns in the source files as measures and dimensions&levels.

· Data Sources - a list of all connected data sources. Each source can be expanded and it lists all available columns. Users can browse the source data by using Data Source Viewer. Columns from a data source window can be dragged & dropped to the dimensions and measures windows accordingly.

· Dimension Map manages the dimensions and levels hierarchy in the data model. It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column.

· Measures - drag & drop columns to manage number figures (facts) in a PowerPlay model.

· PowerCubes - you can specify here a list of cubes created by the model.

· User Classes - define the security.

· Signons - datasource connection information.


Cognos Powerplay Transformer model for the palm nursery business scenario: