IBM Cognos Transformer is a multi-dimensional data modeling component designed for use with IBM Cognos Business Intelligence. 20 Jan Create First Cognos Powerplay Transformer Cubes – Tutorial: Cognos Transformer is a tool to create Cognos Multidimensional cubes (MOLAP). How is IBM Cognos PowerPlay Studio Different from IBM Cognos Series 7 .. through in a cube using Transformer, with any additional settings configured in.
|Published (Last):||10 February 2017|
|PDF File Size:||5.51 Mb|
|ePub File Size:||13.14 Mb|
|Price:||Free* [*Free Regsitration Required]|
Using Cognos Transformer to Convert a Single Table (or Query) Source into a Data Cube
Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures. PowerCubes provide secure and fast data access.
We will get into more details on that options later on in this tutorial. We will analyze the following measures from our tutorial business scenario: Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column.
The dimensions will have the following hierarchy:. It allows creating new dimensions and modifying existing using an user-friendly graphical interface. There are two ways of implementing allocation: Cognos Powerplay Transformer model for the palm tutkrial business scenario: Product and Product Segment.
Users can browse the source data by using Data Source Viewer. The dimensions will have the following hierarchy: Prompt Expressions between R Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available.
Do you want years in the dimension? Cognos provides an automatic support for handling time dimensions which is working very well. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns.
Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs. Follow the steps below to add a new dimension: Put the PowerCube file name: Do you want to generate categories? Choose the first day of the week. Variable costs allocated dynamically by trajsformer The final model structure is shown below: Customers dimension with the source data powerpplay Do you want quarter-years in the time dimension?
Cognos PowerPlay Transformer Tutorial
This measure will be also allocated. But at this stage we don’t want to have Customers grouped by Region, Country and then by Segment becuase it would be cognis intuitive for the end users. Main PowerPlay Transformer features: Customers and Customer Region. A Transformer Model can be also created using a wizard with AutoDesign function or manually.
About Me Siva Mandala. Time dimension is a special type of dimension.
In the following example powfrplay will analyze revenue, constant costs and variable costs. Each source can be expanded and it lists all available columns. The Dimensions Map after adding the products dimensions looks like depicted below: How to treat a week which spans a month? Solutions for issues and Tips on customizing the c Newer Post Older Post Home.
Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: PowerPlay Transformer transfromer The default Cognos Powerplau transformer window is composed of the following windows depicted on the the screenshots below. Fixed costs – calculated per the whole year. 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.