IBM Cognos Analytics and older do not have a version 11 release of Powerplay Transformer for designing and building Powercubes. calculated measure, and a PowerCube Experienced IBM Cognos Transformer in IBM Cognos PowerPlay client, we identify a number of issues with. Problems when Modeling in IBM Cognos Transformer. When a user opens the cube in PowerPlay or one of the IBM Cognos studios, the system verifies that .

Author: Gudal Garr
Country: Guinea-Bissau
Language: English (Spanish)
Genre: Environment
Published (Last): 20 July 2006
Pages: 332
PDF File Size: 6.76 Mb
ePub File Size: 13.8 Mb
ISBN: 485-1-91654-674-8
Downloads: 73229
Price: Free* [*Free Regsitration Required]
Uploader: Kazragar

Do you want months in the time dimension? I do not have much experience with Cubes. The others are optional. Each source can be expanded and it lists all available columns. Variable costs – monthly detail level in a source data. Follow the steps below to add a new dimension:. Powerplay Server is exactly what it sounds like. Cognos Powerplay Transformer model for the palm nursery business scenario: Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available.

The final model structure is shown below: We see below that fixed costs have been allocated transformrr a constant fashion: Time dimension is a special type of dimension. Users can browse the source data by using Data Source Viewer.


Cognos Powerplay Client 2. We will analyze the following measures from our tutorial business scenario:. Do you want days in the time dimension? CSV or Excel output limitatoins Cognos: Time dimension Time ccognos is a special type of dimension. A Transformer Model can be also created using a wizard with AutoDesign function or manually.

Cognos PowerPlay Transformer Tutorial

We can see a new time dimension in the Dimension Map of the model: We will pwoerplay the following measures from our tutorial business scenario: Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: Copyright interview questions Design by: I don’t really see any need for the other two.

Keep in mind that in that case Transformer will try to make a link between the sources based on that columns. To add measures to the model, follow the instructions below:. It will be handled automatically be cognos. Post as a guest Name. Variable costs allocated dynamically by quantity: Do you want years in the dimension? PowerCubes provide secure and fast data access. The dimensions will have the following hierarchy: Product and Product Segment.

Cognos PowerPlay Transformer – Models and Cubes

Go to the PowerCubes window and press Insert key 2. Email Required, but never shown.

PowerCubes provide secure and fast data access. User Classes – define the security. Do you want quarter-years in the time dimension? Choose the first day of the week.


Cognos PowerPlay Transformer tutorial for modelers and datawarehouse developers

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. 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.

Gross revenue – the source data stores sales records on a daily basis. I am trying to install Cognos You must have Transformer to build cubes. The dimensions ccognos have the following hierarchy:. Prompt Expressions between R Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs.

Users can interact with cubes using the standard studios that come with Cognos BI Report Studio, etc. The Dimensions Map after adding the products dimensions looks tranxformer depicted below: There are two ways of implementing allocation: Cognos Powerplay Transformer model for the palm nursery business scenario: