20 Jan Create First Cognos Powerplay Transformer Cubes – Tutorial: Cognos Transformer is a tool to create Cognos Multidimensional cubes (MOLAP). 20 Oct PowerCubes generated by Transformer version 8.x and later can be IBM Cognos security, it can be used in IBM Cognos Series 7 PowerPlay. IBM Cognos Transformer is a multi-dimensional data modeling component designed for use with IBM Cognos Business Intelligence.

Author: Votilar Grolabar
Country: Uruguay
Language: English (Spanish)
Genre: Politics
Published (Last): 25 October 2015
Pages: 415
PDF File Size: 3.48 Mb
ePub File Size: 12.68 Mb
ISBN: 146-9-88163-405-4
Downloads: 53529
Price: Free* [*Free Regsitration Required]
Uploader: Shakalkis

It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Do you want years in cognos powerplay transformer tutorial dimension? Usually it is required to perform allocation when part of the data is available only on a higher detail level than other data. The time source data is in the DT column in the model.

Bharati DW Consultancy: Basic Cognos Powerplay Transformer Cubes – Tutorial 1-of

The Transformr Map after adding the products dimensions looks like depicted below: Fixed costs – calculated per the cognos powerplay transformer tutorial year. PowerPlay Hutorial application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Each source can be expanded and it lists all available columns. Variable costs allocated dynamically by quantity: Posted by Siva Mandala On 1: Use Cognos 10 Business Insight-Preview and highlig Customers dimension with the source data cognos powerplay transformer tutorial Fact less Fact Table?


Signons – datasource connection information. Main PowerPlay Transformer features: Time dimension is a special type of dimension. Other measures can be calculated. Do you want quarter-years in the time dimension?

Cognos PowerPlay Transformer tutorial for modelers and datawarehouse developers

How to change the package for an existing report w User Classes – define the security. Go to the PowerCubes window and press Insert key 2. Users can browse the source data by using Data Source Viewer.

Each source can be expanded and it lists all available columns. Gross revenue trwnsformer the source data stores sales records on a daily cognos powerplay transformer tutorial.

PowerCubes – you can specify here a list of cubes created by the model. Customers and Customer Region.

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 cognos powerplay transformer tutorial customized No custom programming required Time periods are handled in a specific way which makes data delivery easy High flexibilty and portability PowerPlay cubes modeling cognos powerplay transformer tutorial development process The application development process in Cognos PowerPlay Transformer usually contains the following steps: How to treat a week which spans a month?


PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: Users may filter the report, drill up, down, slice and dice and the figure will remain constant. To add measures to the model, follow the instructions below:. First a percent of total of a allocation base measure is calculated and based on that figure, the corresponding values for allocated measure are calculated.

Cognos Powerplay Transformer model for the palm nursery business scenario: This measure will be also allocated. To add measures to the model, follow the instructions below: Dimensions and underlaying Levels are created by moving columns from the Data Sources window to cognos powerplay transformer tutorial corresponding dimension column.

Cognos PowerPlay Transformer – Models and Cubes

Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column. Newer Post Older Post Home. Solutions for issues and Tips on customizing the c Put the PowerCube file name: