Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases

Course Prerequisites

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

After completion of this course; you will learn following:

Essbase Overview

• The Oracle Enterprise Performance Management System
• The Oracle BI Foundation Suite
• The Essbase systematic arrangement

Total Storage Overview

• Aggregate stockpiling key attributes and plan contemplations
• Understanding the total stockpiling generation cycle
• Creating total stockpiling plot chains of command

Planning Data Descriptor Dimensions

• Understanding information descriptor measurements
• Designing time, situation, and records measurements

Structuring Business View Dimensions

• Understanding business view measurements
• Using traits in database structure
• Designing essential and optional chains of command

Stacking Data

• Understanding the total stockpiling information stacking process
• Using information burden cradles
• Loading information steadily

Making Reports with Smart View

• Understanding the Smart View engineering and UI
• Connecting to information sources
• Working with shared and private associations

Collecting Data

• Understanding the information collection process
• Optimizing accumulations
• Designing and running accumulations with the Aggregation Design wizard

Overseeing Aggregate Storage Databases

• Managing tablespaces
• Exporting total stockpiling information
• Optimizing information pressure
• Managing stockpiling stores
• Optimizing layout paging
• Understanding circle space the executives alternatives
• Backing up total stockpiling applications
• Viewing database measurements

Making Basic MDX Queries

• MDX Overview
• Understanding MDX recipe segments and structure
• Identifying measurements and individuals in MDX
• Identifying tuples and sets

Making MDX Formulas

• Using Member Formula Editor
• Creating blend figurings
• Using MDX contingent count devices
• Deriving differences

Time Intelligence Overview

• Understanding the advantages of time insight
• Establishing time insight in total stockpiling applications
• Using the Create Date-Time Dimension wizard

Building Time Intelligent Models

• Creating a date-time measurement
• Using standard schedule types
• Defining part date ranges

Stacking Data Mapped to Dates

• Identifying date pecking orders
• Performing date-based information loads
• Using date-string positions

Making Time Period Reports

• Identifying connected qualities
• Understanding occasional affiliations
• Creating connected quality reports

Ascertaining Time-Based Metrics

• Understanding time measurement structures
• Creating investigation measurements
• Calculating time sensitive measurements
• Using MDX date capacities

Time Balance Calculations

• Using time equalization labels
• Using stream labels

Apportioning Overview

• Identifying information move techniques
• Understanding database parcel types
• Identifying the best segment type to utilize
• Resolving allotment covers
• Following dividing rules

Making Database Partitions

• Designing allotments
• Creating allotments
• Evaluating allotment structures

Making Custom Calculations

• Understanding the work process for making custom computations
• Specifying estimation criteria
• Writing and executing custom estimations

Making Allocations

• Understanding the work process for making ASO assignments
• Specifying assignment criteria
• Specifying assignment and adjusting strategies
• Executing assignments