Loading...

Oracle Essbase 11.1.1: Bootcamp

SKU: 624
$99.00
 (0 reviews)

Oracle Essbase 11.1.1: Bootcamp


Instant download

Immediate secure download link sent right after purchase.

SAP & Oracle Partner

Erpselftraining is a mondial ressource leader for the last 20 years.

100% guarantee

Satisfaction is 100% guarantee. Our support team is always there to support you.

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]

ParameterValue

Add Review