IBM Cognos Transformer: Design OLAP Models (v10.2) (Partnercursus)

• Overview of IBM Cognos BI
• Transformer Fundamentals
• The Transformer Development Process
• Data sources in Transformer
• Building a Model
• Considerations for Designing Successful PowerCubes
• The Time Dimension
• Relative Time
• Use Multiple Data Sources
• Working with Measures
• Allocated Measures
• Currency Conversion

• Alternate Hierarchies within a Dimension
• Advanced Dimensional Modeling
• Customize Cube Content
• Create various types of PowerCubes
• Examine IBM Cognos Security
• Applying Security
• Maintain Models and PowerCubes
• Considerations for Drill Through
• Optimize PowerCubes
• Partition PowerCubes
• Blank Model Plans (Optional)
• Identify Common Data Structures (Optional)

Bekijk meer onderwerpenBekijk minder onderwerpen

• Overview of IBM Cognos BI
  • Discuss IBM Cognos and Performance Management
  • Describe IBM Cognos BI components
  • Explain how to extend IBM Cognos BI
• Transformer Fundamentals
  • Discuss the basics of OLAP analysis
  • Review Transformer capabilities and its role in IBM Cognos 8 BI
  • Discuss Transformer components
  • Define categories and members
• The Transformer Development Process
  • Describe the purpose of a model plan
  • Match business requirements to the model
  • Discuss an approach for creating a model plan
• Data sources in Transformer
  • Discuss the types of data used by Transformer
  • Create data source files and define properties
  • Preview source data and SQL
  • Add IBM Cognos data sources to the model
  • Discuss data filtering
• Building a Model
  • Create model structures and modify property sheets
  • Confirm the data source origin
  • Generate categories to populate the model
  • Modify the model using the dimension diagram
  • Verify the model and create a PowerCube
  • Publish as a data source and package
• Considerations for Designing Successful PowerCubes
  • Describe model types and data entities
  • Define members and member unique names
  • Address changes that Impact a MUN
  • Discuss when category codes can change
• The Time Dimension
  • Define a regular time dimension
  • Examine standard and nonstandard time dimensions
  • Limit the range of valid dates
• Relative Time
  • Compare trends over time
  • Set the current period
  • Create relative time categories
  • Customize relative time categories
• Use Multiple Data Sources
  • Discuss the use of multiple data sources
  • Plan the data sources
  • Define data source types
  • Uniqueness
  • Identify and resolve conflicts between data sources
  • Validate a multiple data source model
  • Discuss a unique move
• Working with Measures
  • Discuss the purpose and uses of measures
  • Describe regular and calculated measures
  • Set measure properties
  • Compare rollup options
  • Create a calculated measure
  • Create calculations before or after rollups
  • Create a category count
• Allocated Measures
  • Discuss measure allocation
  • Allocate measures as a constant and by another measure
  • Check measure distribution
• Currency Conversion
  • Apply and use currency conversion techniques

• Alternate Hierarchies within a Dimension
  • Discuss primary and alternate hierarchies
  • Describe the benefits of alternate hierarchies
  • Create an alternate drill-down path
  • Define convergence levels and identify uniqueness issues
• Advanced Dimensional Modeling
  • Discuss techniques for customizing dimensions
  • Add a new source level to an existing dimension
  • Create a manual level in a dimension
  • Create orphan categories
  • Modify a dimension using a subdimension
  • Create a special category
  • Create a scenario dimension
  • Use calculated columns and categories
• Customize Cube Content
  • Create various types of PowerCubes
  • Omit dimensions and exclude measures
  • Create and apply dimension views
• Examine IBM Cognos Security
  • Examine the security environment
  • Identify the IBM Cognos BI security model
  • Define authentication and authorization
  • Identify security policies
• Applying Security
  • Review model security
  • Create custom views
  • Assign security to custom views
  • Assign custom views to PowerCubes
  • Combine custom views with dimension views
  • Examine a union of custom views
• Maintain Models and PowerCubes
  • Maintain models and PowerCubes
  • Understand data source, model, cube updates
  • Synchronize the model and data source
  • Incrementally update PowerCubes
  • Copy and activate a newer version of the PowerCube without affecting users
• Considerations for Drill Through
  • Identify conformed values between data sources
  • Discuss using drill through in IBM Cognos BI
  • Define a report drill through
  • Define a package-based drill through
  • Identify drill-through values
  • Discuss modeling recommendations
• Optimize PowerCubes
  • Examine cube groups
  • Plan for disk space
  • Optimize PowerCube inputs and outputs
  • Determine factors that affect PowerCube build time and user response time
• Partition PowerCubes
  • Identify the pros and cons
  • Develop a partitioning strategy
  • Create a time-based partitioned cube
  • Automatic vs. manual partitioning
  • Understand multi-file PowerCubes
• Blank Model Plans (Optional)
• Identify Common Data Structures (Optional)