COGNOS POWERPLAY TRANSFORMER TUTORIAL PDF

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: 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 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 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. We strongly recommend to avoid the AutoDesign function as in most cases it does not provide the results expected.

Author:Negis Kagaktilar
Country:Colombia
Language:English (Spanish)
Genre:Life
Published (Last):4 July 2007
Pages:183
PDF File Size:8.29 Mb
ePub File Size:12.57 Mb
ISBN:499-2-66679-174-2
Downloads:21581
Price:Free* [*Free Regsitration Required]
Uploader:Aragore



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: 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 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 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.

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. Cognos Powerplay Transformer model for the palm nursery business scenario:. Transformer Tutorial 2. Transformer Tutorial.

DP460 3M PDF

Cognos PowerPlay Transformer Tutorial

Post a Comment. This tool creates a metadata model file with. Transformer cubes store data in. Lets create our first Cognos Powerplay Transformer cube. High level Steps: Create a Datasource. Create Dimensions. Add Levels to Dimensions.

DERSU UZALA BOOK PDF

IBM Cognos Transformer

.

LR120N DATASHEET PDF

Cognos PowerPlay Transformer - Models and Cubes

.

CHROMATOGRAMME RICHTIG INTEGRIEREN UND BEWERTEN PDF

.

Related Articles