Oracle Essbase 11.1.2 Bootcamp (11.1.2.4)

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
May 13, 202409:0005:00EDTLive Virtual Class5$5,000 USDPurchase
Jul 22, 202410:0006:00EDTLive Virtual Class5$5,000 USDPurchase
Sep 23, 202409:0005:00EDTLive Virtual Class5$5,000 USDPurchase
Nov 18, 202409:0005:00ESTLive Virtual Class5$5,000 USDPurchase


HP11.1.2ESSBC

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
Right Menu IconMENU