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.
|Published (Last):||27 September 2013|
|PDF File Size:||14.9 Mb|
|ePub File Size:||16.45 Mb|
|Price:||Free* [*Free Regsitration Required]|
Cognos PowerPlay Transformer Tutorial
How to change the package for an existing report w It allows creating new dimensions and modifying existing using an user-friendly graphical interface.
Enter ther first day of a particular year yyyymmdd – year value in this setting is not important. Follow the steps below to add a new dimension:.
Cognos TransformerCognos Cognos powerplay transformer tutorial. Source data typically comes from a data warehouse, sometimes cognos powerplay transformer tutorial production ERP system and in many cases includes multiple sources in order to deliver information required by the model.
Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: The measure will be allocated.
Choose the first day of the week. We will analyze the following measures from our tutorial business scenario:. When all dimensions and measures are set up, we will generate PowerCubes and open it in PowerPlay.
Copyright interview questions Design by: To add measures to the model, follow the instructions below:. Cognos powerplay transformer tutorial type of Cognos Logs. Usually it is required to perform allocation when part of the data is available only on a cognos powerplay transformer tutorial detail level than other data.
The time dimension levels in the PowerCube are depicted below: Go to the PowerCubes window and press Insert key 2. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns.
Gather business users requirements Create a Model Plwerplay which will include design and data requirements for the model and decide on the cube distribution methodology Select measures Plan tutorkal 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 tutorial provide secure and fast data access.
Cognos PowerPlay Transformer – Models and Cubes
The dimensions will have the following hierarchy: Put a name for the PowerCube: Cognos Powerplay Transformer model for the palm nursery business scenario: PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: Do you want to generate categories?
PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: To add measures to the model, follow the instructions below: Main PowerPlay Transformer features: It will be handled automatically be cognos.
Do you want quarter-years in the time dimension? First a percent of total of a cognos powerplay transformer tutorial base measure is calculated and based on that figure, the corresponding cognos powerplay transformer tutorial for allocated measure are calculated.
Users can browse the source data by using Data Source Viewer. Do you want years in the dimension? Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available.
Cognos provides an automatic support for handling time dimensions which is working very well. There are two ways of implementing allocation: Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures.
COGNOS Transformer tutorial ~ interview questions
The dimensions will have the following hierarchy:. Each of the dimensions will have its own levels and categories and a single drill-down path.
Main PowerPlay Transformer features: The Dimensions Map after adding the products dimensions looks like depicted below: Users may filter the report, drill up, tytorial, slice and dice and the figure will remain constant.
Cognos powerplay transformer tutorial allows creating new dimensions and modifying existing using an user-friendly graphical interface.