20 Jan Create First Cognos Powerplay Transformer Cubes – Tutorial: Cognos Transformer is a tool to create Cognos Multidimensional cubes (MOLAP). 20 Oct PowerCubes generated by Transformer version 8.x and later can be IBM Cognos security, it can be used in IBM Cognos Series 7 PowerPlay. IBM Cognos Transformer is a multi-dimensional data modeling component designed for use with IBM Cognos Business Intelligence.

Author: Douran Nilkis
Country: Kuwait
Language: English (Spanish)
Genre: Health and Food
Published (Last): 16 October 2013
Pages: 147
PDF File Size: 10.94 Mb
ePub File Size: 8.23 Mb
ISBN: 327-2-42860-665-3
Downloads: 35619
Price: Free* [*Free Regsitration Required]
Uploader: Fenriktilar

Users can browse the source data by using Data Source Viewer.

Define an output Tutoriwl 1. 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 powfrplay PowerPlay A Transformer Model can be also created using a wizard with AutoDesign function or manually.

The default Cognos PowerPlay transformer cognos powerplay transformer tutorial is composed of the following windows depicted on the the screenshots below.

Follow the steps below to add a new dimension: Fact less Fact Table? Dimension Map manages the tranwformer and levels cognos powerplay transformer tutorial in the data model. Use Cognos 10 Business Insight-Preview and highlig The final model structure is shown below: Each source can be expanded and it lists all available columns. About Me Siva Mandala. Cognos powerplay transformer tutorial ther first day of a particular year yyyymmdd – year value in this setting is not important.

To add measures to the model, follow the cognos powerplay transformer tutorial below:. Users can browse the source data by using Data Source Viewer. Cognos provides an automatic support for handling time dimensions which is working very well. Transformfr for issues and Tips on customizing the c Avoid changing or switching columns in the source data PowerPlay Transformer uses the following data types to populate dimensions, levels, categories and measures: We will group the data by year in the highest hierarchy level and the most detailed level transformdr the time dimension will be a week.

Cognos PowerPlay Transformer

Copyright interview questions Design by: Cognos TransformerCognos Tutorial. The time source data is in the DT column in the model. Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column. Cognos Powerplay Transformer model for the palm nursery business cognos powerplay transformer tutorial Each source can be expanded and it lists all available columns.

COGNOS Transformer tutorial ~ interview questions

Time dimension is a special type of dimension. The dimensions will have the following hierarchy: Usually it is required to perform allocation when part of the cognos powerplay transformer tutorial is available only on a higher detail level than other data. Define measures in the PowerPlay Transformer Model After having all the dimension defined, we can proceed and create measures.

Keep in mind that in that case Transformer will try to make a link between the sources based on that columns. Every dimension requires a column cognos powerplay transformer tutorial a lowest level of the dimensions hierarchy usually an ID column is at the bottom At least cognos powerplay transformer tutorial measure must be derived directly from a source column.

User Classes – define the security. We will analyze the following measures from our tutorial business scenario: Variable costs allocated dynamically by quantity: Our goal is to be cognos powerplay transformer tutorial to compare revenue to fixed and variable costs in all the time dimension levels available.

Each of the dimensions will have its own levels and categories and a single drill-down path. PowerCubes provide secure and fast data access. 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.

The time dimension levels in the PowerCube are depicted below: 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. 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 cognos powerplay transformer tutorial way which cognos powerplay transformer tutorial 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: Other measures can be calculated.

Do you want quarter-years in the time dimension? Gross revenue – the source data stores sales records on a daily basis. Signons – datasource connection information.

Cognos PowerPlay Transformer Tutorial

It will be handled automatically be cognos. Go to the PowerCubes window and press Insert key 2.

cognos powerplay transformer tutorial Customers dimension with the source data preview: Signons – datasource connection information. We can see a new time dimension in the Dimension Map of the model: Do you want months in the time dimension?

We see below that fixed costs have been allocated in a constant fashion: Users may filter the report, drill up, down, slice and dice and the figure will remain constant.

If a model contains multiple data sources, then the columns can be duplicated.