Oracle Essbase 11.1.1: Deploy Aggregate Storage Databases

Total time

Oracle Essbase 11.1.1: Deploy Aggregate Storage Databases

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

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 (…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: .

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
Creating Aggregate Storage Databases
  • Aggregate Storage Production Cycle
  • Designing Aggregate Storage Outline Hierarchies
  • Designing Alternate Hierarchies
  • Converting Block Storage to Aggregate Storage
Loading and Aggregating Data
  • Loading Aggregate Storage Data
  • Data Aggregation
  • Optimizing Aggregations
  • Designing and Running Aggregations
Managing Aggregate Storage Databases
  • Tablespace Management
  • Disk Space Management
  • Exporting Data
  • Data Compression
  • Optimizing Aggregate Storage Cache
  • Optimizing Outline Paging
  • Partially Clearing Data
  • Backing Up Aggregate Storage Applications
Partitioning Overview
  • Data Transfer Methods
  • Database Partitioning
  • Partition Types
  • Partitioning Guidelines
  • Partition Overlaps
  • Partition Choices
Creating Database Partitions
  • Outline Differences
  • Creating Partitions
  • Aggregate Storage Partition Designs
  • Creating Write-back Partitions
  • Design Considerations
Creating Basic MDX Queries
  • MDX Overview
  • MDX Queries
  • Identifying Dimensions and Members
  • Selecting Multiple Members
  • MDX Data Model: Tuples and Sets
  • Managing Multiple Sets
Converting Block Storage Member Formulas
  • 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
Creating Basic MDX Formulas
  • Member Formula Editor
  • Accessing MDX Help Documentation
  • Creating Mix Calculations
  • Deriving Variances
  • Calculating Multiple Conditional Outcomes
Time Intelligence Overview
  • Time Intelligence in Aggregate Storage
  • About the Create Date-Time Dimension Wizard
  • Time Intelligence Benefits
Building Time Dimension Models
  • Creating Date-Time Dimensions
  • Supported Calendar Types
  • Date Ranges
Loading Data Mapped to Dates
  • Date Hierarchies
  • Date-Based Data Loads
  • Date-String Formats
  • Loading Time-Based Data
Creating Time Period Reports
  • Linked Attributes
  • Periodic Associations
  • Linked Attribute Mapping
  • Linked Attribute Mapping: Example
  • Creating Linked Attribute Reports
Calculating Time-Based Metrics
  • Time-Based Metrics
  • Calculating with Generic Time Designs
  • Calculating with Fiscal Year Crossover Time Designs
  • Creating Analytics Dimensions
  • MDX Date Functions
Time Balance Calculations
  • 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

There are no reviews yet.

    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.