On-Line Analytical Processing (OLAP)

Test Outline


Basic Knowledge
Classes of OLAP (ROLAP, MOLAP, HOLAP)
Features
Multicubes vs Hypercubes
Products in the Marketplace
Purpose
Usage
Calculations
Cross Dimensional
Dynamic/On-The-Fly
Models
Scopes
Time Series
Data Modeling
Logical / Physical
Metadata
Sparsity
Success Criteria
Techniques
Database Design
Database Sizing
Dimensions
Hierarchies
Partitioning
Reporting
Dimensions
Attributes
Classification
Special (Time, Measures, Accounts)
Hierarchies
Types
Usage
Member
Attributes
Formulas
Keys,Short Names, Longs Names, Aliases
Optimization
OLAP Database
OS Server
Predicting Performance
Relational
Schema
SQL

 

Go Back