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.
|Published (Last):||9 February 2013|
|PDF File Size:||6.4 Mb|
|ePub File Size:||9.74 Mb|
|Price:||Free* [*Free Regsitration Required]|
The tutorial is aligned to a typical business scenario to facilitate the learning process.
COGNOS Transformer tutorial ~ interview questions
How to change the package for an existing report w The tutorial shows how to: Cognos Powerplay Transformer model for the palm nursery business scenario: Customers and Customer Region. The dimensions will have the following hierarchy: Cognos PowerPlay Tutorial Cognos PowerPlay Transformer technical tutorial with examples, sample solutions and a guide to develop data warehouse models in Cognos.
There are also 9 flash movies with guides on how to work with cognos. Split between the two There are two ways of implementing allocation: If a model contains multiple data sources, then the columns can be duplicated.
Reporting and OLAP
Every dimension requires a column on a lowest level of the dimensions hierarchy powerpla an ID column tranaformer at the bottom At least one measure must be derived directly from a source column. Cognos TransformerCognos Tutorial. We will get into more details on that options later on in this tutorial.
We will group the data by year in the highest hierarchy level cognnos the most detailed level in the time dimension will be a week. Users learn how to utilize the Report Studio 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.
In the following example we will analyze revenue, constant costs and variable costs.
Variable costs allocated dynamically by quantity: Do you want to generate categories? PowerCubes provide secure and fast data access. The final model structure is shown below: Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures.
Main PowerPlay Transformer features: The dimensions will have the following hierarchy:. Our goal trasnformer to be able to compare revenue to fixed and variable costs in all the time dimension levels available. Do you want months in the time dimension? Choose the first day of the week.
Follow the steps below to add a new dimension:. PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: Do you want quarter-years in the time dimension? Do you want years in the dimension? Usually it is required to perform allocation when part of the data is available only on a higher detail level than other data. It is a high The time dimension levels in the PowerCube are depicted below: Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: It will be handled automatically be cognos.