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: Meztijas Kajikus
Country: Fiji
Language: English (Spanish)
Genre: Career
Published (Last): 4 March 2013
Pages: 113
PDF File Size: 4.46 Mb
ePub File Size: 14.69 Mb
ISBN: 327-1-13487-603-5
Downloads: 54151
Price: Free* [*Free Regsitration Required]
Uploader: Gut

Reporting and OLAP

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. We will get into more details on that options later on in this tutorial. Do you want days in the time dimension?

CSV or Excel output limitatoins Cognos: There are two ways of implementing allocation: This measure will be also allocated. We can see a new time dimension in the Dimension Map of the model: 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. Posted by Siva Mandala On 1: Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: Users learn how to utilize the Report Studio Follow the steps below to add a new dimension:.

Cognos PowerPlay Tutorial Cognos PowerPlay Transformer technical tutorial with examples, sample solutions and a guide to develop data warehouse models in Cognos. PowerPlay Transformer Guide – Products dimension In this lesson we will create two additional dimensions: Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column. Usually it is required to perform allocation when part of the data is available only on a higher detail level than other data.


IBM Cognos Transformer

If a model contains multiple data sources, then the columns can be duplicated. Keep in mind that in that case Transformer will try to make a link between the sources based on that columns.

The tutorial shows how to: Cognos ReportNet navigation – with introduction, system navigation and It is located under Cognos menu entry and is divided into the following sections: Our goal is to be able to compare revenue to fixed and variable costs in all the time dimension levels available.

The dimensions will have the following hierarchy: Do you want quarter-years in the time dimension? Prompt Expressions between R Insert data into an empty crosstab, nest, replace, sort data in a cube Explore data by changing Gross revenue – the source data stores sales records on a daily basis. Put the PowerCube file name: The tutorial is aligned to a typical business scenario to facilitate the learning process.

The Dimensions Map after adding the products dimensions looks like depicted below: The most active forums are: PowerCubes provide secure and fast data access. Use Cognos 10 Business Insight-Preview and highlig Cognos Powerplay Transformer – multiple data sources in a model with the data source definition: Other measures can be calculated.


Time dimension is a special type of dimension. Put a name for the PowerCube: 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.

A Transformer Model can be also created using a wizard with AutoDesign function or manually.

Cognos Tutorial Trainings Powerplay Movies Analysis Studio Quick

The dimensions will have the following hierarchy:. It gives a brief overview of Cognos Impromptu and explains how to connect to powerply data mart and explore data.

Each of the dimensions will have its own levels and categories and a single drill-down path. It allows creating new dimensions and modifying existing using an user-friendly graphical interface. It is addressed to data Cognos Tutorials And Trainings.

Cognos provides an automatic support for handling time dimensions which is working very well. We see below that fixed costs have been allocated in a constant fashion: Product and Product Segment. If not needed, we suggest to generate them based on the data and do not generate a category for each day. Different type of Cognos Logs.