How is IBM Cognos PowerPlay Studio Different from IBM Cognos Series 7 .. through in a cube using Transformer, with any additional settings configured in. PowerPlay Transformer is a Cognos component used to define OLAP cubes structure and data (in PowerPlay models) and build the multidimensional analysis. COGNOS – Powerplay. Powerplay Transformer combines all of the data into a summarized format called a PowerCube.• The PowerCube.
|Published (Last):||19 September 2007|
|PDF File Size:||1.72 Mb|
|ePub File Size:||11.27 Mb|
|Price:||Free* [*Free Regsitration Required]|
IBM Cognos Transformer
The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. We see below that fixed costs have been allocated in a constant fashion: It is addressed to data The dimensions will have the following hierarchy: Choose the first day of the week.
This options allows users for instance to report fiscal years starting from 1 March. The final model structure is shown below: Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: We will analyze the following measures from our tutorial business scenario: Define an output PowerCube 1.
Cognos provides an automatic support for handling time dimensions which is working very well.
Follow the steps below to add a new dimension:. There are two ways of implementing allocation:.
This measure will be also allocated. Do you want quarter-years in the time dimension?
Other measures can be calculated. PowerCubes provide secure and fast data access. Cognos PowerPlay Tutorial Cognos PowerPlay Transformer technical tutorial with examples, sample solutions and a guide to develop data warehouse models in Clgnos. Fixed costs – calculated per the whole year.
Poserplay less Fact Table? Insert data into an empty crosstab, nest, replace, sort data in a cube Explore data by changing User Classes – define the security. Cognos TransformerCognos Tutorial.
Bharati DW Consultancy: Basic Cognos Powerplay Transformer Cubes – Tutorial 1-of
Solutions for issues and Tips on customizing the c Each source can be expanded and it lists all available columns. The time source data is in the DT column in the model. Variable costs – monthly detail level in a source data. Do you want to generate categories? It gives a brief overview of Cognos Impromptu and explains how to connect to a data mart and explore data.
Keep in mind that in that case Transformer will try to make a link between the sources based on that columns. Every dimension 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.
IBM Cognos Transformer
It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs. 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. Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available.
Split between the two Posted by Siva Mandala On 1: Justcog Cognos forums Cognos discussion forums where Cognos users may find relevant information in resolving cognos issues. Do you want years in the dimension?
Cognos Powerplay Transformer model for the palm nursery business scenario: