Oracle Essbase 11.1.1 Bootcamp

ReportSource Education Centre
London, London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' DURATION

5 days

AUDIENCE

Database Designers
Database Administrators
Business Intelligence Developer
Developer

COURSE OBJECTIVES

Create block storage databases
Create dimensions using rules files
Load data using rules files
Analyze data with Smart View
Describe multidimensional calculation
Create basic database calculations
Analyze dimension attributes
Analyze non-numeric data

COURSE OUTLINE AND TOPICS

Essbase Overview:

Multidimensional Analysis
Oracle’s Enterprise Performance Management System
Oracle BI Suite Enterprise Edition Plus Essbase
Production Environment Components

Designing Applications and Databases:

Block Storage Implementation Process
Analyzing and Planning Implementations
Creating Applications and Databases
Creating Outline Structures
Modifying Member Properties

Designing Data Descriptor Dimensions:

Data Descriptor Dimensions Overview
Designing Time Dimensions
Designing Scenario Dimensions
Outline Calculations
Designing Accounts Dimensions
Testing Outline Calculations

Optimising Data Descriptor Dimensions:

Creating Member Aliases
Dimension Types
Creating Period-to-Date Totals
Dynamic Calc Members
Enhancing Accounts Dimensions
Optimizing Data Storage

Planning Dimension Designs:

Business View Dimensions Overview
Combining Business Views
Planning Dimensions with Label Outlines

Creating Basic Dimension Build Rules Files:

Rules Files Overview
Creating Dimension Build Rules Files
Configuring Dimension Maintenance Settings

Creating Advanced Dimension Build Rules Files:

Advanced Dimension Build Rules Files Overview
Creating Shared Members
Manipulating Fields
Creating User-Defined Attributes

Loading Data:

Data Load Overview
Creating Data Load Rules Files
Selecting and Rejecting Records
Capturing New Members

Getting Started with Smart View:

Smart View Overview
Configuring Data Sources
Creating Ad Hoc Reports
Setting the Point of View

Creating Reports with Smart View:

Manipulating Multidimensional Data
Updating Essbase Data
Integrating Essbase Data with Microsoft Office
Customizing the User Experience

Data Storage and Calculation:

Calculation Overview
Database Calculation Order
Data Block Fundamentals
Data Blocks and the Index System
Database Statistics
Data Block Creation
Database Calculation Process

Creating Calculation Scripts:

Calculation Script Organization
Returning Correct Calculation Results
Troubleshooting CALC DIM Processes
Controlling the Calculation Process
Top-Down Calculation
Focusing Calculations with FIX Statements
Calculating Conditionally with IF Statements
Comparing FIX and IF Calculation Processes

Referencing Members in Calculations:

Referencing Members Explicitly
Referencing Members Dynamically
Creating Calculation Variables

Analysing Member Attributes:

Attribute Dimensions Overview
Adding Attribute Dimensions to Outlines
Design Considerations
Creating Attributes with Rules Files

Analysing Varying Attributes:

Varying Attributes Overview
Creating Varying Attributes Overview
Viewing Varying Attribute Data

Analysing Text and Dates:

Typed Measures Overview
Enabling Typed Measures
Creating Typed Measures
Viewing Typed Measures
Calculations Based on Typed Measures ...''

Elements of this syllabus are subject to change.

Phone:0207 614 8050

School Address/Venue(s):

4 Broadgate

Jobs & Resumes: London
Houses & Roommates: London
Travel Agencies: London

Search other schools for Oracle Essbase 11.1.1 Bootcamp training resources.

oracle hyperion planning 11.1.1 create & manage applications
hyperion integration services 9.3.1 create & manage data structures
hyperion interactive reporting 9.3.1 design reports and dashboards
hyperion interactive reporting 11.1.1 design reports & dashboards

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.