Duration: 4 Days
What you will learn
You learn the principles of aggregate storage database design, then how to build, load, report from, and manage
aggregate storage databases, constructing the sixteen-dimension in-class database through a series of guided
exercises.
Learn to:
Design, develop, and deploy aggregate storage databases
Manage aggregate storage databases
Construct variance, mix, and other member calculations using MDX
Implement time intelligence for time period reporting
Describe custom calculations and allocations in aggregate storage databases
Additional topics give you an in-depth view of (and hands-on practice in) important elements of ASO development,
including complex member formulas, time intelligence, partitioning, and the new features in Release 11.1.2, calculation
templates and allocations.
Audience
Developer
Sales Consultants
Support Engineer
Technical Consultant
Related Training
Required Prerequisites
Knowledge of Microsoft Windows and Excel
Knowledge of principles from Oracle Essbase Bootcamp course
Course Objectives
Create ASO databases
Load data into ASO databases
Aggregate ASO data
Design aggregate storage (ASO) databases
Manage ASO databases
Construct member formulas
Build time-intelligent models
Describe custom calculations and allocations in aggregate storage databases
Course Topics
Essbase Overview
The Oracle Enterprise Performance Management System
The Oracle BI Foundation Suite
The Essbase analytic solution
Aggregate Storage Overview
Aggregate storage key characteristics and design considerations
Understanding the aggregate storage production cycle
Creating aggregate storage outline hierarchies
Designing Data Descriptor Dimensions
Understanding data descriptor dimensions
Designing time, scenario, and accounts dimensions
Designing Business View Dimensions
Understanding business view dimensions
Using attributes in database design
Designing primary and secondary hierarchies
Loading Data
Understanding the aggregate storage data loading process
Using data load buffers
Loading data incrementally
Creating Reports with Smart View
Understanding the Smart View architecture and user interface
Connecting to data sources
Working with shared and private connections
Aggregating Data
Understanding the data aggregation process
Optimizing aggregations
Designing and running aggregations with the Aggregation Design wizard
Managing Aggregate Storage Databases
Managing tablespaces
Exporting aggregate storage data
Optimizing data compression
Managing storage caches
Optimizing outline paging
Understanding disk space management options
Backing up aggregate storage applications
Viewing database statistics
Creating Basic MDX Queries
MDX Overview
Understanding MDX formula components and structure
Identifying dimensions and members in MDX
Identifying tuples and sets
Creating MDX Formulas
Using Member Formula Editor
Creating mix calculations
Using MDX conditional calculation tools
Deriving variances
Time Intelligence Overview
Understanding the benefits of time intelligence
Establishing time intelligence in aggregate storage applications
Using the Create Date-Time Dimension wizard
Building Time Intelligent Models
Creating a date-time dimension
Using standard calendar types
Defining member date ranges
Loading Data Mapped to Dates
Identifying date hierarchies
Performing date-based data loads
Using date-string formats
Creating Time Period Reports
Identifying linked attributes
Understanding periodic associations
Creating linked attribute reports
Calculating Time-Based Metrics
Understanding time dimension designs
Creating analytics dimensions
Calculating time-based metrics
Using MDX date functions
Time Balance Calculations
Using time balance tags
Using flow tags
Partitioning Overview
Identifying data transfer methods
Understanding database partition types
Identifying the best partition type to use
Resolving partition overlaps
Following partitioning guidelines
Creating Database Partitions
Designing partitions
Creating partitions
Evaluating partition designs
Creating Custom Calculations
Understanding the workflow for creating custom calculations
Specifying calculation criteria
Writing and executing custom calculations
Creating Allocations
Understanding the workflow for creating ASO allocations
Specifying allocation criteria
Specifying allocation and rounding methods
Executing allocations
Formateur
0.00 average based on 0 ratings