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.

Author: Vushura Kilar
Country: Vietnam
Language: English (Spanish)
Genre: Love
Published (Last): 26 January 2011
Pages: 84
PDF File Size: 20.62 Mb
ePub File Size: 13.88 Mb
ISBN: 707-7-51584-276-8
Downloads: 7836
Price: Free* [*Free Regsitration Required]
Uploader: Mausar

The Dimensions Map after adding the products dimensions looks like depicted below: There are two ways of implementing allocation:.

Cognos ReportNet navigation – with introduction, system navigation and The time dimension levels in the PowerCube are depicted below: The Analysis Studio Quick Tour teaches the basic skills needed to analyze business results. Justcog Cognos forums Cognos discussion forums where Cognos users may find relevant information in resolving cognos issues.

Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: It allows creating new dimensions and modifying existing using an user-friendly graphical interface.


Do you want years in the dimension? Prompt Expressions between R PowerCubes provide secure and fast data access. If a model contains multiple data sources, then the columns can be duplicated.

Go to the Rutorial window transfoemer press Insert key 2. Each source can be expanded and it lists all available columns. The time source data is in the DT column in the model. About Me Siva Mandala. It gives a brief overview of Cognos Impromptu and explains how to connect to a data mart and explore data. Customers dimension with the source data preview: In the following example we will analyze revenue, constant costs and variable costs.

COGNOS Transformer tutorial ~ interview questions

We will get into more details on that options later on in this tutorial. We will analyze the following measures from our tutorial business scenario:.

Transsformer options allows users for instance to report fiscal years starting from 1 March. It will be handled automatically be cognos. Follow the steps below to add a new dimension:.

Reporting and OLAP

Product and Product Segment. Do you want to generate categories? 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. Signons – datasource connection information.


Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available. 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.

Keep in mind that in that case Transformer will try to make a link powegplay the sources based on that columns. Cognos TransformerCognos Tutorial. Split between the two Cognos provides an automatic support for handling time dimensions which is working very well.