How is IBM Cognos PowerPlay Studio Different from IBM Cognos Series 7 .. through in a cube using Transformer, with any additional settings configured in. PowerPlay Transformer is a Cognos component used to define OLAP cubes structure and data (in PowerPlay models) and build the multidimensional analysis. COGNOS – Powerplay. Powerplay Transformer combines all of the data into a summarized format called a PowerCube.• The PowerCube.

Author: Brajin Balar
Country: Maldives
Language: English (Spanish)
Genre: Science
Published (Last): 2 July 2008
Pages: 285
PDF File Size: 2.87 Mb
ePub File Size: 2.29 Mb
ISBN: 598-5-85433-789-7
Downloads: 86317
Price: Free* [*Free Regsitration Required]
Uploader: Basho

Use Cognos 10 Business Insight-Preview and highlig PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: It is located under Cognos menu entry and is divided into the following sections: Users can browse turorial source data by using Data Source Viewer.

In the following example we will analyze revenue, constant costs transfomrer variable costs. Cognos TransformerCognos Tutorial. The most active forums are: Variable costs – monthly detail level in a source data.

We will group the data by year in the highest hierarchy level and the most detailed level in the time dimension will be a week. We will analyze the following measures from our tutorial business scenario: The dimensions will have the following hierarchy: The default Cognos PowerPlay transformer window is composed of the following transormer depicted on the the screenshots below.

Cognos ReportNet navigation – with introduction, system navigation and The tutorial shows how to: A Transformer Model can be also created using a wizard with AutoDesign function or manually.


IBM Cognos Transformer

It gives a brief overview of Cognos Impromptu and explains how to connect to a data mart and transfotmer data. Fixed costs – calculated per the whole year.

The powerplah will be allocated. It allows creating new dimensions and modifying existing using an user-friendly graphical interface. To add measures to the model, follow the instructions below: Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available. Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: Define an output PowerCube 1.

IBM Cognos Transformer

The time source data is in the DT column in the model. About Me Siva Mandala. Follow the steps below to add a new dimension:. Usually it is required to perform allocation when part of the data is available only on a higher detail level than other data. Customers dimension with the source data preview: The Dimensions Map after adding the products dimensions looks like depicted below: Each source can be expanded and it lists all available columns.

It is a high Do you want to generate categories? We will get into more details on that options later on in this tutorial. The dimensions will have the following hierarchy:.

If not needed, we suggest to generate them based on the data and do not generate a category for each day. Cognos PowerPlay Tutorial Cognos PowerPlay Transformer technical tutorial with examples, sample solutions and a guide to develop data warehouse models in Cognos.

Prompt Expressions between R Put the PowerCube file name: Customers and Customer Region. Do you want quarter-years in the time transforjer But at this stage we don’t want to have Customers grouped by Region, Country and then by Segment transformmer it would be not intuitive for the end users.


Gather business users requirements Create a Model Plan which will include design and data requirements for the model and decide on the cube distribution methodology Select measures Plan dimensions and levels Design and develop the PowerPlay model in Transformer Create PowerPlay cubes and distribute them to the end users Analyze powerpplay explore the cube data using PowerPlay A Transformer Model can be also created using a wizard with AutoDesign function or manually.

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

Enter ther first day of a tansformer year yyyymmdd – year value in this setting is not important. Source data typically comes from a data warehouse, sometimes from production ERP system and in many cases includes multiple sources in order to deliver information required by the model.

Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures. The final model rransformer is shown below: Fact less Fact Table? It is addressed to data Variable costs allocated dynamically by quantity: