LIT Essbase Contents

Oracle Essbase

1.Essbase Overview

·         Multidimensional Analysis

·         Oracle’s Enterprise Performance Management System

·         Essbase

·         Production Environment Components

2.Designing Applications and Databases

·         Creating Applications and Databases

·         Creating Outlines

3.Designing Data Descriptor Dimensions

·         Data Descriptor Dimensions Overview

·         Designing Time Dimensions

·         Designing Scenario Dimensions

·         Outline Calculations

·         Designing Accounts Dimensions

·         Testing Outline Calculations

4.Optimizing Data Descriptor Dimensions

·         Creating Member Aliases

·         Dimension Types

·         Creating Period-to-Date Totals

·         Dynamic Calc Members

·         Enhancing Accounts Dimensions

·         Optimizing Data Storage

5.Developing Dimension Designs

·         Business View Dimensions Overview

·         Attributes in Database Design

·         Combining Business Views

·         Developing Label Outlines

6.Creating Basic Dimension Build Rules Files

·         Rules Files Overview

·         Creating Dimension Build Rules Files

·         Configuring Dimension Maintenance Settings

7.Creating Advanced Dimension Build Rules Files

·         Advanced Dimension Build Rules Files Overview

·          Creating Shared Members

·          Manipulating Fields

·          Creating User-Defined Attributes

·          Creating Attribute Dimensions with Rules Files

8. Loading Data

·         Data Load Overview

·          Creating Data Load Rules Files

·          Selecting and Rejecting Records

·          Capturing New Members

9.Getting Started with Smart View

·          Navigating Smart View

·          Connecting to Data Sources

·          Creating Ad Hoc Grids

·          Setting the Point of View

·          Associating Data Sources with Worksheets

·          Creating Free-Form Grids

·          

10.Creating Reports with Smart View

·         Updating Essbase Data

·          Integrating Essbase Data with Microsoft Office

·          Creating Shared Database Perspectives