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: Badal Najas
Country: Honduras
Language: English (Spanish)
Genre: Education
Published (Last): 21 August 2011
Pages: 62
PDF File Size: 7.19 Mb
ePub File Size: 20.76 Mb
ISBN: 831-1-14226-652-3
Downloads: 64893
Price: Free* [*Free Regsitration Required]
Uploader: Torisar

Go to the PowerCubes window and press Insert key 2.

It is located under Cognos menu transfprmer and is divided into the following sections: The final model tutoriak is powerplqy below: The data source properties window also allows users to choose the datasource type, point to the right file or database server and set up a number of processing options, like: Do you want years in the dimension?

The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. 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 and explore the cube data using PowerPlay A Transformer Model can be also created using a wizard with AutoDesign function or manually.

Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: CSV or Excel output limitatoins Cognos: Usually it is required to perform allocation when part of the data is available only on a higher detail level than other data.


A Transformer Model can be also created using a wizard with AutoDesign function or manually.

It gives a brief overview of Cognos Impromptu and explains how to connect to a data mart and explore data. Variable costs allocated dynamically by quantity: It will be handled automatically be cognos. Other measures can be calculated. The tutorial is aligned to a typical business scenario to facilitate the learning process. We will analyze the following transformef from our tutorial business scenario:.

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

Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available. About Me Siva Mandala. We will group the data by year in the highest hierarchy level and the most detailed level in the time dimension will be transfformer week.

Put a name for the PowerCube: PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Do you want quarter-years in the time dimension?

IBM Cognos Transformer

Every dimension requires a column on a lowest level of the dimensions hierarchy usually an ID column is at the bottom Tranaformer least one measure must be derived directly from a source column. If a model contains multiple data sources, then the columns can be duplicated.

We will get into more details on that options later on in this tutorial. PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: Choose the first day of the week. The time dimension levels in the PowerCube are depicted below: Do you want to generate categories? Users learn how to cognso the Report Studio Use Cognos 10 Business Insight-Preview and highlig But at this stage we don’t want to have Customers grouped by Region, Country and then by Segment becuase it would be not intuitive for the end users.


Cognos Powerplay Transformer model for the palm nursery business scenario: Time dimension Time dimension is a special type of dimension. Define an output PowerCube 1.

IBM Cognos Transformer

Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: Do you want days in the time dimension?

There are two ways of implementing allocation:. Signons – datasource connection information. To add measures to the model, follow the instructions below: Prompt Expressions between R Posted by Siva Mandala On 1: Time tutoril is a special type of dimension.

Reporting and OLAP

This ppowerplay allows users for instance to report fiscal years starting from 1 March. The Dimensions Map after adding the products dimensions looks like depicted below: Justcog Cognos forums Cognos discussion forums where Cognos users may find relevant information in resolving cognos issues.

Follow the steps below to add a new dimension:.

Split between the two Cognos TransformerCognos Tutorial. Each of the dimensions will have its own levels and categories and a single drill-down path. The measure will be allocated.

To add measures to the model, follow the instructions below:.