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.
|Genre:||Health and Food|
|Published (Last):||6 September 2013|
|PDF File Size:||18.4 Mb|
|ePub File Size:||8.18 Mb|
|Price:||Free* [*Free Regsitration Required]|
Cognos provides an cognos powerplay transformer tutorial support for handling time dimensions which is working very well. Main PowerPlay Cognos powerplay transformer tutorial features: 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.
Usually it is required to perform allocation when part tranformer the data is available only on a higher detail level than other data. Customers and Customer Region.
The data source properties window also allows users to choose the datasource type, tarnsformer to the right file or database server and set up a number of processing options, like: We see below that fixed costs have been allocated in a constant fashion: A Transformer Model can be also created using a wizard with AutoDesign function or manually. Do you want months in the time dimension?
Source data typically comes from a data warehouse, sometimes from production ERP system and in many cases includes multiple sources cognos powerplay transformer tutorial order to deliver information required by cognos powerplay transformer tutorial pwerplay.
Cognos PowerPlay Transformer – Models and Cubes
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. Solutions for issues and Tips on customizing the c To add measures to the ttansformer, follow the instructions below: This options allows users for instance to report fiscal years starting from 1 March. The default Cognos PowerPlay transformer window is composed of the powwerplay windows depicted on the the screenshots below.
PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: It allows creating new dimensions and modifying existing using an user-friendly graphical interface. We will analyze cognos powerplay transformer tutorial following measures from our tutorial business scenario: Data sources recommendations Column names in a data source must be unique. Do you want quarter-years in the cognos powerplay transformer tutorial dimension?
Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available. Put a name for the PowerCube: It will be handled automatically be cognos.
Cognos PowerPlay Transformer Tutorial
Follow the steps below to add a new dimension:. Split between coynos two User Classes – define the security. In the following example we will analyze revenue, constant costs and variable costs. Do you want to generate categories? Fact less Fact Cognos powerplay transformer tutorial
Cognos PowerPlay Transformer
Enter ther first day of a particular year yyyymmdd – year value in this setting is cognos powerplay transformer tutorial important. There are two ways of implementing allocation: Keep in mind that in that case Transformer will try to make a link between the sources based on that columns.
We will get into more details on that options later on in this tutorial. Different type of Cognos Logs.
When all dimensions and measures are set up, we will generate PowerCubes and open it in Tutoroal. Cognos Powerplay Transformer model for the palm nursery business scenario: Go to the PowerCubes window and press Insert key 2. Choose the first day of cognos powerplay transformer tutorial week.
transfofmer About Me Siva Mandala. Posted by Siva Mandala On 1: PowerCubes provide secure and fast data access. The dimensions will have the following hierarchy:.
Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column. Customers dimension with the source data preview: To transflrmer measures to the model, follow the instructions below:. Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: Keep in mind that Cognos cubes are static and building a PowerCube is cognos powerplay transformer tutorial repetitive process cubes cognos powerplay transformer tutorial be refreshed every day, every month or even once a year.
Gross revenue – the source data stores sales records on a daily basis. Time dimension is a special type of dimension. CSV or Excel output limitatoins Cognos: If a model contains tutoriaal data sources, then the columns can be duplicated.
The time dimension levels in the PowerCube are depicted below: Every dimension requires a cognos powerplay transformer tutorial on a lowest level of the dimensions hierarchy usually an ID column is cognos powerplay transformer tutorial the bottom At least one measure must be derived directly from a source column. Avoid changing or switching columns in the source data PowerPlay Transformer uses tuttorial following data types to populate dimensions, levels, categories and measures: Product and Product Segment.
Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column.