Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases Training in Sioux City

Enroll in or hire us to teach our Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases class in Sioux City, Iowa by calling us @303.377.6176. Like all HSG classes, Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
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
Course Length: 4 Days
Course Tuition: $2260 (US)

Prerequisites

Suggested: - Knowledge of Microsoft Windows and Excel - Knowledge of principles from Oracle Essbase Bootcamp course

Course Outline

 
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

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.