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: Mooguktilar Zologrel
Country: Gabon
Language: English (Spanish)
Genre: Life
Published (Last): 15 December 2008
Pages: 260
PDF File Size: 10.29 Mb
ePub File Size: 10.6 Mb
ISBN: 683-2-96735-721-5
Downloads: 73806
Price: Free* [*Free Regsitration Required]
Uploader: Zulkitaur

This options allows users for instance to report fiscal years starting from 1 March. Copyright interview questions Design by: 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.

Each source can be expanded and it lists all available columns. If not needed, we suggest to generate them based on the data and do not generate a cognls for each day. Dimensions and underlaying Levels are created by moving columns from the Data Sources window powwerplay the corresponding dimension column.

Cognos PowerPlay Transformer Tutorial

Users may filter the report, drill up, down, trwnsformer and dice and the figure will remain constant. Enter ther first day of a particular year yyyymmdd – year value in this setting is not important. PowerCubes provide secure and fast data access. Sign up or log in Sign up using Google. Data sources recommendations Column names in a data source must be unique.


There are two ways of implementing allocation: Time dimension is a special type of dimension.

IBM Cognos Transformer

Other measures can be calculated. Customers and Customer Region.

The dimensions will have the following hierarchy: If a model contains multiple data sources, then the columns tranformer be duplicated. Main PowerPlay Transformer features: Dimension Map manages the dimensions and levels hierarchy in the data model.

CSV or Excel output limitatoins Cognos: Do you want quarter-years in the time dimension?

We strongly recommend to avoid the AutoDesign function as in most cases it does not provide the results expected. Sign up using Email and Password. Powerplqy Transformer Guide – Products dimension In this lesson we will create two additional dimensions: The time source data is in the DT column in the model.

Choose the first day of the week. 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: Prompt Expressions between R Solutions for issues and Tips on customizing the c Do you want days in the time dimension? Avoid changing or switching columns in the source data PowerPlay Transformer uses the transformr data types to populate dimensions, levels, categories and measures: I do not have much experience with Cubes.


Transformer is used to design and build cubes. Sign up using Facebook.

Cognos PowerPlay Transformer tutorial for modelers and datawarehouse developers

In the following example we will analyze revenue, constant costs and variable costs. Data Sources – a list of all connected data sources. When all dimensions and measures cognod set up, we will generate PowerCubes and open it in PowerPlay. Customers dimension with the source data preview: The time dimension levels in the PowerCube are depicted below: Put a name for the PowerCube: Do you want months in the time dimension?

Gather business users requirements Create a Model Plan which will include design and data requirements for the model and decide pwoerplay the cube transflrmer 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.

You must have Transformer to build cubes.