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: Gardalkis Kam
Country: French Guiana
Language: English (Spanish)
Genre: Sex
Published (Last): 20 October 2006
Pages: 187
PDF File Size: 11.78 Mb
ePub File Size: 3.60 Mb
ISBN: 491-1-33840-189-9
Downloads: 8133
Price: Free* [*Free Regsitration Required]
Uploader: Faull

Cognos PowerPlay Transformer Tutorial

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. About Me Siva Mandala. Measures allocation real-life example in Cognos In trajsformer following example we will analyze revenue, constant costs and variable costs.

Users can browse the source data by using Data Source Viewer. PowerCubes provide secure and fast data access.

Main PowerPlay Transformer features: Sign up using Email and Password. If a model contains multiple data sources, then the columns can be duplicated. Customers and Customer Region. Choose the first day of the week. Gather business users requirements Create a Model Plan which will include design and data requirements for the model and decide on the cube distribution methodology Select measures Plan dimensions cogmos levels Design and develop the PowerPlay model in Transformer Create PowerPlay cubes and distribute them to the end users Analyze and explore the cube data using PowerPlay A Transformer Model can be also created using a wizard with AutoDesign function or manually.


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: Other measures can be calculated.

Bharati DW Consultancy: Basic Cognos Powerplay Transformer Cubes – Tutorial 1-of

PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: Sign up or log in Sign up using Google. This measure will be also allocated. Time dimension is a special type of transfomrer.

Thanks Andrew for the response. 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. It will be handled automatically be cognos. User Classes – define the security. Split between the two Do you want quarter-years in the time dimension?

We will analyze the following measures from our tutorial business scenario:. 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.

Cognos PowerPlay Transformer – Models and Cubes

Different type of Cognos Logs. Do you want days in the time dimension? Cognos Powerplay Transformer model for the palm nursery business scenario: Main PowerPlay Transformer features: Fact less Fact Table?

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. I don’t really see any need for the other two. 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 website is subject to these policies.


How you intend for your users to interact with the cubes determines what you need.

COGNOS Transformer tutorial ~ interview questions

In the following example we will analyze revenue, constant costs and variable costs. 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: Data sources recommendations Column names in a data source must be unique.

Powerplay Client is a desktop tool for reading the cube. Dimension Map manages the dimensions and levels hierarchy in the data model. Do you want years in the dimension? Do you want months in the xognos dimension? We can see a new time dimension in the Dimension Map of the model: Transformeer Dimensions Map after adding the products dimensions looks like depicted below: The final model structure is shown below: We see below that fixed costs have been allocated in a constant fashion: Post as a guest Name.

This options allows users for instance to report fiscal years starting from 1 March. Fixed costs – calculated per the whole year. Newer Post Older Post Home. Cognos Powerplay Client 2.