Prospects, This is the Only place Where YOu can Find All Interview questions,Faqs and Real Stuff and scenario & Scripts with Resumes, Stick to It for Updates,,,,

Monday, February 4, 2008

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: