Oracle Hyperion Training

Dimensions, Hierarchies and Members

Create Essbase Application

Essbase Application Physical Path

Generation Reference Method

Level Reference Method

Parent Child Reference Method

Building Dimensions Using SQL Source

Handling Empty Fields During Dimension Build

Remove Dimension Members

Loading Data Using Rules File

Adding Dimension to Outline After Loading Data

Free Form Data Loading

Member Consolidation Properties

Quiz 1: Member Consolidation Operators

Data Storage Properties - Part 1

Data Storage Properties - Part 2

Data Storage Properties - Part 3

Alias Tables

Sparse and Dense Dimension Concepts

Sparse and Dense Dimension Recap

Attribute Dimensions

Retrieving Attribute Dimension Data Using Smart View

Attribute Dimension Types

Build Attribute Dimension Using Rules file

Time Dimension

Time Dimension Properties

Variance Reporting

Two Pass Calculations

User Defined Attributes - Part 1

User Defined Attributes - Part 2

Quiz 2: Data Storage Properties

Essbase Calculations - Introduction

AGG VS CALC DIM

Datacopy and Cleardata

Fix Commands - Introduction

Fix Commands - Calc All, Calc Dim, SubVars

Nested FIX Vs. IF Statements

Set Commands - Part 1

Set Commands - Part 2

Set CalcTaskDims

Set CreateBlockoneq ON/OFF

Set CreateBlockoneq ON/OFF - Recap

Set CreateNonMissing Block

Create Blocks Using Datacopy

UDA Example

Attribute Dimension Calculation Example

Inventory Calculations

Xref Example

Xwrite Example

Allocation Requirement - Sample

Marketing Expense Allocation Script

@Return Function

Run time Substitution Variables in Calculation Scripts