course:
duration: 1-3 day
description:

This course teaches users to build PowerCubes using Cognos Transformer. The course focuses on applying Best Practices to create PowerCubes that will effectively meet the needs of the business.
prerequisites:

Impromptu and Powerplay Basics is recommended, as is being comfortable working with databases and having an overall understanding of Cognos products and functionality of each component.
course contents:
Module 1: Dimensional Modeling
› Dimension vs. Measure
› Special dimension
› Date dimension
Module 2: Getting your data
› Single Query
› Multiple Query
› Different data sources
Module 3: Transformer Basics
› Building dimensions
› Building measures
› Building cubes
Module 4: Relative Time
› Single period
› N period running total
› Calculations
Module 5: Working with measures
› Rollup
› Calculations
› Formats
Module 6: Special Techniques
› Manual Levels
› Customizing PowerCubes
› Drilling through to Impromptu

Dimensional Strategies Inc. 1998
Print this page Email this page to a colleague Info