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):||12 February 2012|
|PDF File Size:||2.18 Mb|
|ePub File Size:||17.86 Mb|
|Price:||Free* [*Free Regsitration Required]|
Other measures can be calculated. A Transformer Model can be also created using a wizard with AutoDesign function or manually.
We will get into more details on that options tutoriial on in this tutorial. To add measures to the model, follow the instructions below:. The measure will be allocated.
Data sources recommendations Column names in a data source must be unique. Users may filter the report, drill up, down, slice and dice and the figure will remain constant. Put the PowerCube file name: The dimensions will have the following hierarchy: Split between the two When all dimensions and measures are set up, we will generate PowerCubes and open it in PowerPlay. The final model structure is shown below: Cognos provides an automatic support for handling time dimensions which is working very well.
Newer Post Older Post Home. PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: If a model contains multiple data sources, then the columns can be duplicated.
PowerCubes provide secure and fast data access.
Fact less Fact Table? Time dimension Time dimension is a special type of dimension. How to change the package for an existing report w 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. We will analyze the following measures from our tutorial business scenario:. Time dimension is a special type of dimension.
Keep in mind that Cognos cubes are static and building a PowerCube is a repetitive process cubes may be refreshed every day, every yransformer or even once a year. Cognos TransformerCognos Tutorial. Different type of Cognos Logs.
The Dimensions Map after adding the products dimensions looks like depicted below: 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.
Cognos PowerPlay Transformer tutorial for modelers and datawarehouse developers
Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available. Variable costs allocated dynamically by quantity: We can see a new time dimension in the Dimension Map of the model: Fixed costs – calculated per the whole year. Do you want months in the time dimension?
Product and Product Segment. Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs. It allows creating new transformerr and modifying existing using an user-friendly graphical interface.
Cognos PowerPlay Transformer Tutorial
User Classes – define the security. Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures.
Customers dimension with the source data preview: