Oracle Essbase Studio allows professionals to quickly and efficiently build applications using various data and metadata sources, thus giving them ample time to interpret results and modify models accordingly. Participants enrolled for this Oracle Essbase Studio 11.1.2 Create & Manage Data Structures course will learn to use a development tool that combines cube construction into one single interface, which gives steady performance for data loading and outline building.
This training program how to use a common single user console to connect to various data sources, create & catalog hierarchies and dimensions, set properties to generate Essbase outlines and load that data successfully. You will also learn various features including lineage tracking, drill-through etc. in order to make your model efficient and fast.
Course Objectives :
- Understanding the architecture of Essbase Studio
- Understanding and applying the implementation process for Essbase Studio
- Creating cube models, metadata elements, schemas and hierarchies
- Loading data and dimension members to Essbase
- Defining relational tables and drill-through reports
- Copying, moving, and backing up your Essbase Studio catalog
This training module is specifically meant for those using Essbase Studio 184.108.40.206 version and is not suitable for those working with its earlier versions.
|Schedule for Oracle Essbase Studio 11.1.2: Create & Manage Data Structures (220.127.116.11)|
|Course Contents||Regular Track
|Oracle Essbase Studio 11.1.2: Create & Manage Data Structures (18.104.22.168)||3|
|Balance Days for day of arrival and practice||1|
Familiarity with dimensional data modeling and data warehousing Familiarity with relational database concepts and SQL Working knowledge of Essbase Suggested Prerequisites Oracle Essbase 11.1.2 Bootcamp Oracle Essbase 11.1.2: Deploy Aggregate Storage Database