PDP Url

Oracle Essbase Studio 11.1.2: Create & Manage Data Structures (11.1.2.2) (OR-ESS-C&MDS)

This course shows you how to create and manage Essbase cubes using Essbase Studio. The course covers a wide variety of data and metadata sources, including relational (RDBMS, OBIEE), dimension server, and flat files.

Virtual

Learning Style

Intermediate

Difficulty

3 Days

Course Duration

Course Info

Download PDF

Certificate

See Sample

Buy Individually
About Individual Course:
  • Individual course plan gives you access to this course
$2,640.00
$2,640.00
/ Seat
This course shows you how to create and manage Essbase cubes using Essbase Studio. The course covers a wide variety of data and metadata sources, including relational (RDBMS, OBIEE), dimension server, and flat files.

Course Information

About this course:

In today's competitive business world, Essbase developers must be able to build applications quickly and efficiently, often using a variety of data and metadata sources. Essbase Studio provides Essbase professionals with a development tool that consolidates cube construction activities into a single interface, with consistent performance for outline building and data loading.

This course gives you the information you need to build your Essbase models quickly from many sources, giving you more time to interpret results and modify your models as required. Whether you are sourcing from a relational database, data warehouse, EPMA dimension server, or flat files, you can use the elements, hierarchies, and models you build in Essbase Studio in your next project--and the next one after that. This course shows you how to connect to the most commonly used data sources, how to build and catalog dimensions and hierarchies, and how to set Essbase properties to produce Essbase outlines and load data--all from a single user console. In addition, you learn features such as lineage tracking (for change control) and drill-through (for the extra-cube details you need) to make your Essbase modeling fast and efficient.

* This course is designed for customers using Oracle Essbase Studio 11.1.2.2. This course is not suitable for customers using Oracle Essbase Studio 11.1.2.1 or earlier.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Course Objective:

  • Describe the Essbase Studio implementation process
  • Describe the Essbase Studio implementation process
  • Build metadata elements, hierarchies, schemas, and cube models
  • Load dimension members and data to Essbase
  • Define drill-through reports to relational tables
  • Copy, move, and backup your Essbase Studio catalog

Audience:

  • Application Developers
  • Implementation Consultant
  • Business Intelligence Developer

Prerequisite:

  • Familiarity with dimensional data modeling and data warehousing
  • Familiarity with relational database concepts and SQL
  • Working knowledge of Essbase

Outline

More Information

More Information
Brand Oracle
Subjects Big Data
Lab Access No
Technology Oracle
Learning Style Virtual Classroom
Difficulty Intermediate
Course Duration 3 Days
Language English

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Course Prerequisites

Contact A Learning Consultant


click here