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):||26 September 2013|
|PDF File Size:||2.27 Mb|
|ePub File Size:||14.75 Mb|
|Price:||Free* [*Free Regsitration Required]|
Define an output PowerCube 1.
It is located under Cognos menu entry and is divided into the following sections: It is powerplaj to data Cognos provides an automatic support for handling time dimensions which is working very well.
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. There are two ways of implementing allocation: How to treat a week which spans a month?
IBM Cognos Transformer
We will analyze the following measures from our tutorial business scenario:. Do you want days in the time dimension?
Dimensions and underlaying Levels are created by moving columns from the Data Sources window to transfomer corresponding dimension column. Each source can be expanded and it lists all available columns.
Posted by Siva Mandala On 1: The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. The tutorial shows how to: Split between the two Product and Product Segment. User Classes – define the security.
Variable costs allocated dynamically by quantity: In the following example we will analyze revenue, constant costs and variable costs. Each of the dimensions will have its own levels and categories and a single drill-down path.
The measure will be allocated.
Customers dimension with the source data preview: To add measures to the model, follow the instructions below: When all dimensions and measures are set up, we will generate PowerCubes and open it in PowerPlay. Put the PowerCube file name: Gross revenue – the source data stores sales records on a daily basis. The data source properties window also allows users to choose the datasource type, point to the right file or database server and set up a number of processing options, like: Solutions for issues and Tips on customizing the c The Analysis Studio Quick Tour teaches the basic skills needed to analyze business results.
Follow the steps below to add a new dimension: The Dimensions Map after powerplaay the products dimensions looks like depicted below: The dimensions will have the following hierarchy:.
Using Cognos Transformer to Convert a Single Table (or Query) Source into a Data Cube
Users may filter the report, drill up, down, slice and dice and the figure will remain constant. 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.
Use Cognos 10 Business Insight-Preview and highlig