Oracle Essbase 11.1.2: Deploy Aggregate Storage

Databases Ed 1

Cost $4000

Course Code
D71310GC10

Duration
4 days

Format
Live Virtual Class

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.

Prerequisites

Required Prerequisite

  • Knowledge of Microsoft Windows and Excel
  • Knowledge of principles from Oracle Essbase Bootcamp course

Audience

  • Administrator
  • Developer
  • End User
  • Implementer

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

Topics

  • Essbase Overview,Aggregate Storage Overview,Designing Data Descriptor Dimensions,Designing Business View Dimensions,LoadingData,Creating Reports with Smart View,AggregatingData,Managing Aggregate Storage Databases,Creating Basic MDX Queries,Creating MDX Formulas,Time Intelligence Overview,Building Time Intelligent Models,Loading Data Mapped to Dates,Creating Time Period Reports,Calculating Time-Based Metrics,Time Balance Calculations,PartitioningOverview,Creating Database Partitions,Creating Custom Calculations,Creating Allocations

Enroll for Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases Ed 1

Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases Ed 1

$4,000.00

Clear
SKU: D71310GC10 Categories: ,

Additional information

Schedules

Jan 18 2022 – Jan 21 2022 (4 days) 9:00 AM – 5:00 PM US-Eastern, Jul 11 2022 – Jul 14 2022 (4 days) 9:00 AM – 5:00 PM US-Pacific

Format

Live Virtual Class

Reviews

There are no reviews yet.

Be the first to review “Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases Ed 1”

Your email address will not be published. Required fields are marked *

No products were found matching your selection.

Follow-on Courses

Browse the suggested follow-on courses below and continue your training journey. We offer training in various learning formats, from instructor-led to virtual, so you can choose what works best for you. Get started by selecting a course to learn more.

No products were found matching your selection.

TOP
0