COGNOS POWERPLAY TRANSFORMER PDF

Purpose This guide gives a check list when quality reviewing a Transformer model. The check list is a suggested proven practice. By comparing your models against the items within this check list you will be able to go a fair way in stating that you have a good Transformer model that follows a number of proven practices. These rules are not set in stone. Users may have valid reasons to deviate from these rules. Any deviations should be documented so that those following in your footsteps understand why standard proven practices have not been followed.

Author:Brataxe Tojarn
Country:Iceland
Language:English (Spanish)
Genre:Science
Published (Last):11 August 2014
Pages:358
PDF File Size:7.99 Mb
ePub File Size:6.18 Mb
ISBN:975-9-11491-305-9
Downloads:53883
Price:Free* [*Free Regsitration Required]
Uploader:Groran



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. Main PowerPlay Transformer features: 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 specific way which makes 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: 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 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.

We strongly recommend to avoid the AutoDesign function as in most cases it does not provide the results expected. PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Data Sources - a list of all connected data sources. Each source can be expanded and it lists all available columns. Users can browse the source data by using Data Source Viewer. Dimension Map manages the dimensions and levels hierarchy in the data model.

It allows creating new dimensions and modifying existing using an user-friendly graphical interface. Dimensions and underlaying Levels are created by moving columns from the Data Sources window to the corresponding dimension column. PowerCubes - you can specify here a list of cubes created by the model.

User Classes - define the security. Signons - datasource connection information.

ITEXTSHARP CREATE SEARCHABLE PDF

Cognos PowerPlay Transformer - Models and Cubes

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. Main PowerPlay Transformer features: 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 specific way which makes 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: 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 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. We strongly recommend to avoid the AutoDesign function as in most cases it does not provide the results expected. PowerPlay Transformer application The default Cognos PowerPlay transformer window is composed of the following windows depicted on the the screenshots below. Data Sources - a list of all connected data sources.

LEO BROUWER PIEZA SIN TITULO PDF

Cognos PowerPlay Transformer Tutorial

It is described in more detail here: Business Scenario - a palm and tropical plants nursery which implements Cognos as an analysis and reporting platform which monitors performance on sales, costs and forecasts. Cognos PowerPlay Transformer Guide for data warehouse developers 1. Transformer overview - Introduction to PowerPlay Transformer with the components overview and application development process definition 3. Products dimensions - Create dimensions for Products in the tutorial model 6. Define Measures - Define measures in the tutorial model and create the PowerCube 7.

PAUL REUSS NEUTRON PHYSICS PDF

PowerPlay Transformer Model Check List

.

Related Articles