Duration: 3 Days
What you will learn
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.
Audience
Application Developers
Business Intelligence Developer
Implementation Consultant
Prerequisites
Required Prerequisites
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 Databases
Course Objectives
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
Course Topics
Essbase Studio Overview
Benefits of Essbase Studio
Essbase Studio Architecture
Essbase Studio Workflow
Creating Data Source Connections
Creating Connections with Connection Wizard
Defining Connections to Text file Data Sources
Defining Connections to Relational Data Sources
Creating Metadata Elements
Creating metadata elements
Managing metadata elements
Building Hierarchies
Creating Standard Hierarchies
Creating Measure Hierarchies
Building Parent-Child hierarchies
Creating Cube Schemas
Building cube schemas with Cube Schema Wizard
Choosing measures and hierarchies for cube schemas
Creating Essbase Models
Creating Essbase models from cube schemas
Setting Essbase model properties
Setting dimension and member properties
Validating your Essbase models
Deploying Essbase Cubes
Deploying cubes using Cube Deployment Wizard
Setting load options for deploying cubes
Enhancing Your Data Source Connections
Managing data source connections
Creating minischemas
Enhancing Your Metadata Elements
Creating date elements
Creating derived text measures
Creating editing, and managing alias sets
Enhancing Hierarchies
Building alternate hierarchies
Adding attribute dimensions to your hierarchies
Building calendar hierarchies
Creating varying attribute hierarchies
Enhancing Cube Schemas
Defining data load mappings
Creating Essbase models from Cube Schema Wizard
Enhancing Essbase Models
Enhancing model, dimension, and member properties
Enhancing Cube Deployments
Deferring deployments
Troubleshooting
Setting up incremental loads
Viewing deployment history
Viewing Lineage
Navigating the Lineage Viewer
Viewing the history of an element
Editing data element properties
Editing Essbase model properties
Showing deployment history
Viewing sample data
Working with Drill-through Reports
Drill-through reporting overview
Creating drill-through reports
Customizing reports
Associating drill-through reports with Essbase models
Performing drill-through reporting in Smart View
Managing the Essbase Studio Repository
Exporting the Essbase Studio catalog
Copying, moving, and backing up the Essbase Studio catalog
Integrating Essbase Studio with Oracle Business Intelligence
Connecting to OBIEE
Creating OBIEE dimensions and cube schemas
Generating key and caption bindings for OBIEE
Formateur
0.00 average based on 0 ratings