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: Nizshura Nar
Country: Liechtenstein
Language: English (Spanish)
Genre: Software
Published (Last): 18 December 2011
Pages: 165
PDF File Size: 1.78 Mb
ePub File Size: 11.62 Mb
ISBN: 693-4-82780-264-2
Downloads: 38101
Price: Free* [*Free Regsitration Required]
Uploader: Faetaur

About Me Siva Mandala. Keep in mind that Cognos cubes are static and building a PowerCube is a repetitive process cubes may be refreshed every day, every month or even once a year. Powerplay Client is a desktop tool for reading transforrmer cube.

Newer Post Older Post Home. Andrew 5, 1 13 I don’t really see any need for the other two. Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below.

How to change the package for an existing report w We will analyze the following measures from our tutorial business scenario: Email Required, but never shown. Cognos Powerplay Transformer model for the palm nursery business pwerplay Enter ther first day of a particular year yyyymmdd – year value in this setting is not important. Dimensions and underlaying Levels are powetplay by moving columns from the Data Sources window to the corresponding dimension column.

Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the transfomrer is subject to these policies.


Cognos provides an automatic support for handling time dimensions which is working very well. Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available.

Gross revenue transfirmer the source data stores sales records on a daily basis. Transformer is used to design and build cubes. We will get into more details on that options later on in this tutorial. cogns

IBM Cognos Transformer

The final model structure is shown below: But at this stage we don’t want to have Customers grouped by Region, Country and then by Segment becuase it would be not intuitive for the end users. User Classes – define the security. There are two ways of implementing allocation:.

Cognos Powerplay Client 2. Fact less Fact Table? It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Other measures can be calculated. PowerCubes provide secure and fast data access.

Cognos PowerPlay Transformer Tutorial

Customers dimension with the source data preview: Users can browse the source data by using Data Source Viewer. Sign up or log in Sign up using Google.

Put the PowerCube ttransformer name: Measures allocation real-life example in Cognos In the following example we will analyze revenue, constant costs and variable costs. By using our site, you acknowledge that you have read and understand our Cookie PolicyPowerrplay Policyand our Terms of Service.

Cognos PowerPlay Transformer

Cognos TransformerCognos Tutorial. Fixed costs – calculated per the whole year. Each source can be expanded and it lists all available columns. Powerplay Server is exactly what it sounds like.

Users can browse the source data by using Data Source Viewer. Can someone please explain the difference between Cognos Powerplay client, Transformdr server and Cognos transformer. User Classes – define the security.


This measure will be also allocated. Post as a guest Name.

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 trasnformer the model. The dimensions will have the following hierarchy:. Each source can be expanded and it lists all available columns.

Time dimension Time dimension is a special type of dimension. Advanced modelling capabilities Leverages aggregate and fact tables Intergation of the query data into the model The models are defined by dimension structures and measures which can be easily customized No custom programming required Time periods are handled in a specific way which makes data delivery easy High flexibilty and portability PowerPlay cubes modeling and development process The application development process in Cognos PowerPlay Transformer usually contains the following steps: If a model contains multiple data sources, then the columns can be duplicated.

We strongly recommend to avoid the AutoDesign function as in most cases it does not provide the results expected. I do not have much experience with Cubes. Posted by Siva Mandala On 1: Variable costs allocated dynamically by quantity: A Transformer Model can be also created using a wizard with AutoDesign function or manually. Each of the dimensions will have its own levels and categories and a single drill-down path.