IBM Cognos 8 BI Transformer: Design OLAP Models (V8.4) Eğitimi

Ön Kayıt ve Fiyat Bilgi Formu

Tarih ve lokasyonlar

Bu eğitimi özel sınıf olarak kendi kurumunuzda talep edebilirsiniz.
Lütfen bizimle iletişime geçin:

+90 212 282 7700

Talep Formu
Eğitim Tipi ve Süresi

3 Days ILT    

IBM Cognos 8 BI Transformer: Design OLAP Models (V8.4) (B2482G )

IBM Course Code: J0482G

IBM Cognos 8 BI Transformer: Design OLAP Models (V8.4) is a four-day, self-paced course that provides you with knowledge of OLAP modeling concepts using Transformer. You will learn how to design, build, and maintain PowerCubes for use in IBM Cognos 8 BI so that end users can easily analyze data.

Who Needs to Attend

This expert course is for developers who design OLAP models for use in IBM Cognos 8 BI.


  • Understand the business need for ad hoc queries and analysis
  • Experience gathering requirements and analyzing data

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Overview of Cognos 8 BI

  • Discuss IBM Cognos 8 and Performance Management
  • Describe IBM Cognos 8 BI components
  • Explain how to extend IBM Cognos 8 BI

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

3. 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
  • Review the relationship of the model plan to the Transformer model

4. 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 Cognos 8 data sources to the model
  • Discuss Business Viewpoint Studio
  • Discuss data filtering
5. 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

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

7. The Time Dimension

  • Discuss the purpose of a time dimension
  • Define a regular time dimension
  • Examine standard and nonstandard time dimensions
  • Limit the range of valid dates

8. Relative Time

  • Compare trends over time
  • Set the current period
  • Create relative time categories
  • Customize relative time categories

9. Use Multiple Data Sources

  • Discuss the use of multiple data sources
  • Plan the data sources
  • Define data source types

10. Uniqueness

  • Identify and resolve conflicts between data sources
  • Validate a multiple data source model
  • Discuss a unique move

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

12. Allocated Measures

  • Discuss measure allocation
  • Allocate measures as a constant and by another measure
  • Check measure distribution

13. Currency Conversion

  • Apply and use currency conversion techniques

Eğitim içeriğini PDF olarak indir

Eğitim Sağlayıcı ve Kategori

IBM  » Cognos Business Intelligence (V 8.4) Eğitimler
Business Analysis  » Business Analysis Eğitimler