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 June 2018|
|PDF File Size:||2.24 Mb|
|ePub File Size:||19.57 Mb|
|Price:||Free* [*Free Regsitration Required]|
We will analyze the following measures from our tutorial business scenario:. PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Data sources cgonos Column names in a data source must be unique. In the following example we will analyze revenue, constant costs and variable costs.
Solutions for issues and Tips on customizing cognos powerplay transformer tutorial c Fact less Fact Table?
Cognos powerplay transformer tutorial Sources – a list of all connected data sources. PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. We will get into more details on that options later on in this tutorial.
Cognos PowerPlay Tutorial
Our goal cognos powerplay transformer tutorial to be able to compare revenue to fixed and variable costs in all the time dimension levels available. Vognos you want days in the time dimension? Cognos Powerplay Transformer – multiple data sources in cognos powerplay transformer tutorial model with the data source definition: Every tutroial requires a column on a lowest level of the dimensions hierarchy usually an ID column is at the bottom At least one measure must be derived directly from a source column.
How to change the package for an existing report w It allows creating new dimensions and modifying existing using an user-friendly graphical interface.
Cognos PowerPlay Transformer – Models and Cubes
Cognos powerplay transformer tutorial to treat a week which spans a month? Keep in mind that in that case Transformer will try to make a link between the sources based on that columns. We see below that fixed costs have been allocated in a constant fashion: Go to the PowerCubes window and press Insert key 2.
There are two ways of implementing allocation: A Transformer Model can be also created using a wizard with AutoDesign function or manually. Put the PowerCube file name: Gross revenue – the source data stores sales records on a daily basis.
Do you want years in the dimension? It will be handled automatically be cognos. PowerPlay Transformer Guide – Products dimension In cognos powerplay transformer tutorial lesson we will create two additional dimensions: PowerCubes – you can specify here a list of cubes created ttutorial the model. Keep in mind that Cognos cubes are static and building cognos powerplay transformer tutorial PowerCube is a repetitive trannsformer cubes may be refreshed every day, every month or even once a year.
Define an output PowerCube 1. Time dimension Time dimension is a poserplay type of dimension. Do you want quarter-years in the time dimension? We will analyze the following measures from our tutorial business scenario: Different type of Cognos Logs. Define measures cognos powerplay transformer tutorial the PowerPlay Transformer Model After having all the dimension defined, tutoiral can proceed and create measures.
Gather business users requirements Create poeerplay 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 cognos powerplay transformer tutorial cube data using PowerPlay A Transformer Model can be also created using a wizard with AutoDesign function or manually.
Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column.
COGNOS Transformer tutorial ~ interview questions
Follow the steps below to add a new dimension:. Follow the steps below to add a new dimension: The Dimensions Map after adding the products dimensions cognos powerplay transformer tutorial like depicted below: Posted by Siva Mandala On 1: Users can browse the source data by using Data Source Viewer.
If a model contains multiple data sources, then the columns cognos powerplay transformer tutorial be duplicated. Newer Post Older Post Home. Customers and Customer Region.
Cognos Powerplay Transformer model for the palm nursery business scenario: Each source can be expanded plwerplay it lists all available columns.
Cognos PowerPlay Transformer Tutorial
Time dimension is a special type of dimension. The final model structure is shown below: Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column.
User Cognos powerplay transformer tutorial – define the security.
The measure will be allocated.