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: Toshicage Gurisar
Country: Spain
Language: English (Spanish)
Genre: Career
Published (Last): 28 May 2004
Pages: 180
PDF File Size: 14.77 Mb
ePub File Size: 16.64 Mb
ISBN: 712-5-45995-304-7
Downloads: 19056
Price: Free* [*Free Regsitration Required]
Uploader: Kanos

How to change the package for an existing report w Users may filter the report, drill up, down, slice and dice and the figure will remain constant.

The final model structure is shown below: Variable costs allocated dynamically by quantity: Put a name for the PowerCube: We will analyze the following measures from our tutorial business scenario: About Me Siva Mandala.

Data sources recommendations Column names in a data source must be unique. Customers dimension with the source data preview: Main PowerPlay Transformer features: Go to the PowerCubes window and press Insert key 2. Tutoriial is located under Cognos menu entry and is divided into the following sections: Cognos PowerPlay Tutorial Cognos PowerPlay Transformer technical tutorial with examples, sample solutions and a guide to develop data warehouse models in Cognos.

Different type of Cognos Logs. Usually it is required to perform allocation when part of the data is available only on a higher detail level than other data.


Split between the two The time dimension levels in the PowerCube are depicted below: Variable costs – monthly detail level in a source data. The most active forums are: If not needed, we suggest to generate them based on the data and do not generate a category for each day.

Reporting and OLAP

How to treat a week which spans a month? First a percent of total of a allocation base measure is calculated and based on that figure, the corresponding values for allocated measure are calculated.

Follow the steps below to add a new dimension: Do you want months in the time dimension? 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. PowerCubes provide secure and fast data access. Each source can be expanded and it lists all available columns. The Analysis Studio Quick Tour teaches the basic skills needed transformef analyze business results.

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, transfotmer This options allows users for instance to report fiscal years starting from 1 March.

We will get into more details on that options later on in this tutorial. 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 and 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.


IBM Cognos Transformer

Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures. Insert data into an empty crosstab, nest, replace, sort data in a cube Explore data by changing Gross revenue – the source data stores sales cognnos on a daily basis.

Fixed costs – calculated per the whole year.

Do you want days tutorkal the time dimension? Other measures can be calculated. Signons – datasource connection information. 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 Transformer tutorial ~ interview questions

The measure will be allocated. Cognos provides an automatic support for handling time dimensions which is working very well.

We see below that fixed costs have been allocated in xognos constant fashion: To add measures to the model, follow the instructions below: We will analyze the following measures from our tutorial business scenario:. Choose the first day of the week.