Oracle Essbase 11.1.1: Deploy Aggregate Storage Databases
Starting dates and places
This product does not have fixed starting dates and/or places.
Description
This course shows you how to deploy aggregate storage databases in Oracle Essbase. You learn the fundamental differences between block storage and aggregate storage databases and requirements for database design and deployment. You learn how to convert existing block storage database outlines to aggregate storage and how to create aggregate storage databases. You also learn about database partitioning as it relates to aggregate storage databases and about MDX for building member formulas. You finish with an in-depth discussion of time intelligence. Exercises provide hands-on practice.
* This course is also suitable for customers using Hyperion Essbase Analytics 9.3.1.
A Live Virtual Class (…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
This course shows you how to deploy aggregate storage databases in Oracle Essbase. You learn the fundamental differences between block storage and aggregate storage databases and requirements for database design and deployment. You learn how to convert existing block storage database outlines to aggregate storage and how to create aggregate storage databases. You also learn about database partitioning as it relates to aggregate storage databases and about MDX for building member formulas. You finish with an in-depth discussion of time intelligence. Exercises provide hands-on practice.
* This course is also suitable for customers using Hyperion Essbase Analytics 9.3.1.
A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.
Audience
- Business Intelligence Developer
- Database Designers
- Developer
- Technical Consultant
- Database Administrators
Course Topics Essbase Overview
- Oracle's Enterprise Performance Management System
- Oracle BI Suite Enterprise Edition Plus
- Essbase Analytic Solution
- Data Analysis Needs
- Aggregate Storage Overview
- Aggregate Storage Production Cycle
- Designing Aggregate Storage Outline Hierarchies
- Designing Alternate Hierarchies
- Converting Block Storage to Aggregate Storage
- Loading Aggregate Storage Data
- Data Aggregation
- Optimizing Aggregations
- Designing and Running Aggregations
- Tablespace Management
- Disk Space Management
- Exporting Data
- Data Compression
- Optimizing Aggregate Storage Cache
- Optimizing Outline Paging
- Partially Clearing Data
- Backing Up Aggregate Storage Applications
- Data Transfer Methods
- Database Partitioning
- Partition Types
- Partitioning Guidelines
- Partition Overlaps
- Partition Choices
- Outline Differences
- Creating Partitions
- Aggregate Storage Partition Designs
- Creating Write-back Partitions
- Design Considerations
- MDX Overview
- MDX Queries
- Identifying Dimensions and Members
- Selecting Multiple Members
- MDX Data Model: Tuples and Sets
- Managing Multiple Sets
- Elements Common to Block Storage and MDX Formulas
- Elements Unique to MDX Formulas
- Function Return Types
- Converting Formulas to MDX
- Aggregate Storage Calculation Order
- Considerations for Custom Functions and Macros
- Member Formula Editor
- Accessing MDX Help Documentation
- Creating Mix Calculations
- Deriving Variances
- Calculating Multiple Conditional Outcomes
- Time Intelligence in Aggregate Storage
- About the Create Date-Time Dimension Wizard
- Time Intelligence Benefits
- Creating Date-Time Dimensions
- Supported Calendar Types
- Date Ranges
- Date Hierarchies
- Date-Based Data Loads
- Date-String Formats
- Loading Time-Based Data
- Linked Attributes
- Periodic Associations
- Linked Attribute Mapping
- Linked Attribute Mapping: Example
- Creating Linked Attribute Reports
- Time-Based Metrics
- Calculating with Generic Time Designs
- Calculating with Fiscal Year Crossover Time Designs
- Creating Analytics Dimensions
- MDX Date Functions
- Time Balance Tags
- Flow Tags
Course Objectives
- Write member formulas with MDX
- Create aggregate storage databases
- Perform fundamental management tasks for aggregate storage databases
- Partition block and aggregate storage databases
- Build time-intelligent aggregate storage models
- Implement time intelligence for time period reporting
- Differentiate between block storage and aggregate storage databases
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.