Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
May 29, 2023 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
Jul 24, 2023 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
Sep 25, 2023 | 10:00 | 06:00 | EDT | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
Nov 27, 2023 | 09:00 | 05:00 | EST | Toronto - In Class or by Video Conference | 5 | $5,000 USD | Purchase |
Oracle Essbase 11.1.2 Bootcamp (11.1.2.4)
In this course, you learn the principal techniques and theories for the design of Essbase block storage databases. Block storage databases are deployed independently for budgeting, forecasting, and planning, and as the underlying data storage and analytic engine for Hyperion Planning applications. You will create a database outline, load data into the database, and analyze data with Smart View. You also create calculation scripts (to calculate data for different scenarios) and perform advanced analysis on the database by implementing varying attribute dimensions and typed measures. Design discussions and hands-on activities help you practice the skills taught.
Duration: 5 Days
Audience
- Business Intelligence Developers
- Database Administrators
- Database Designers
- Developers
Learning Objectives
- Create basic database calculations
- Analyze dimension attributes
- Analyze non-numeric data
- Create block storage databases
- Create dimensions using rules files
- Load data using rules files
- Analyze data with Smart View
- Describe multidimensional calculation
Topics
- Essbase Overview
- Designing Applications and Databases
- Designing Data Descriptor Dimensions
- Developing Dimension Designs
- Creating Basic Dimension Build Rules Files
- Creating Advanced Dimension Build Rules Files
- Loading Data
- Getting Started with Smart View
- Creating Reports with Smart View
- Data Storage and Calculation
- Creating Calculation Scripts
- Controlling the Calculation Process
- Referencing Members in Calculations
- Developing and Testing Complex Calculation Scripts
- Normalizing Data
- Creating Attribute Dimensions
- Analyzing Varying Attributes
- Analyzing Text and Dates