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 January 2004|
|PDF File Size:||18.45 Mb|
|ePub File Size:||12.33 Mb|
|Price:||Free* [*Free Regsitration Required]|
Enter ther first day of a particular year yyyymmdd – year value in this setting is not important.
The dimensions will have the following hierarchy:. Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column. The time source clgnos is in the DT column in the model. The Dimensions Map after adding the products dimensions looks like depicted below: The most active forums are: How to treat a week which spans a month?
Gross revenue – the source data stores sales records on a daily basis. The tutorial shows how to: It is a high Follow tutoriak steps below to add a new dimension:. Define an output PowerCube 1. It is addressed to data Follow the steps below to add a new dimension: The final powerppay structure is shown below: Go to the PowerCubes window and press Insert key 2.
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. Do you want quarter-years in the time dimension? Cognos ReportNet navigation – with introduction, system navigation and Copyright interview questions Design by: Signons – datasource connection information.
The time dimension levels in the PowerCube are depicted below: We will analyze the following measures from our tutorial business scenario: Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures. Tutoriial you want months in the time dimension? Different type of Cognos Logs. We see below that fixed costs have been allocated in a constant fashion: The tutorial is aligned to a typical business scenario to facilitate the learning process.
Prompt Expressions between R It allows creating new dimensions and modifying existing using an user-friendly graphical interface.
COGNOS Transformer tutorial ~ interview questions
We can see a new cognoe dimension in the Dimension Map of the model: The measure will be allocated. About Me Siva Mandala. There are two ways of implementing allocation:. 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. Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available. 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: Do you want days in the time dimension?
Reporting and OLAP
Put a name for the PowerCube: Variable costs allocated dynamically by quantity: Cognos TransformerCognos Tutorial.
Time dimension Time dimension is a special type of dimension. It will be handled automatically be cognos.
PowerCubes provide secure and fast data access. There are also 9 flash movies with guides on how to work with cognos.
Each of the dimensions will have its own levels and categories and a single drill-down path. Cognos provides an automatic support for handling time dimensions which is working very well.
Choose the first day of the week. Posted by Siva Mandala On 1: Customers dimension with the source data preview: But at this stage we don’t want to have Customers grouped by Region, Country and then cognox Segment becuase it would be not intuitive for the end users.