Oracle Essbase 11.1.1: Bootcamp
Description
This course gives students the opportunity to learn the principal techniques and theories for the design of block storage databases with Essbase Release 11.1.1. Students create a database outline, load data into the database, analyze data with Smart View, create calculation scripts, and perform advanced analysis. In addition, design discussions and hands-on practice sessions help reinforce the skills taught.
Learn to:
-
Create block storage databases
-
Develop database outlines manually and using rules files
-
Load data
-
Analyze data using Smart View
-
Calculate block storage databases
-
Analyze attributes and textual data
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 textual data
Topics:
Essbase Overview
Multidimensional Analysis
Oracle's Enterprise Performance Management System
Essbase "“ System 9
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
Optimizing 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
Dimension Build 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
Retrieving Data
Setting the Point of View
Creating Reports with Smart View
Manipulating Multidimensional Data
Updating Essbase Data
Integrating Essbase Data with Microsoft Office
Creating Smart Slices
Creating Reports with Report Designer
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
Analyzing Member Attributes
Attribute Dimensions Overview
Adding Attribute Dimensions to Outlines
Design Considerations
Creating Attributes with Rules Files
Analyzing Varying Attributes
Varying Attributes Overview
Creating Varying Attributes
Viewing Varying Attributes
Analyzing Textual Data
Textual Data Overview
Creating Text Measures
Viewing Text Measures in Smart View
Shipping
Shipping is free IMMEDIATE DOWNLOAD AFTER PAYMENT .Receive a direct download link in your email in 1 - 3 minutes.
[Do NOT forget to check the junk or Spam mails of your email box]
99.00 $
