|
|
Oracle Essbase (+Integration with BI)
|
Termin do uzgodnienia.
Prosimy o kontakt: tel. +48 12 616 43 80 | | 3 dni | | 270 USD (podana cena nie zawiera podatku VAT 23%) |
Oracle Essbase is the industry-leading multi-dimensional online analytical processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. By leveraging its self-managed, rapid application development capabilities, business users can quickly model complex business scenarios. For example, line-of-business personnel can simply and rapidly develop and manage analytic applications that can forecast likely business performance levels and deliver "what-if" analyses for varying conditions. Oracle Essbase supports extremely fast query response times for vast numbers of users, large data sets, and complex business models.
Partner Academy's offer is concordant and reserved only for Oracle Partners who have current OPN membership.
Day 1
Welcome, Overview, and Introductions
Oracle Essbase Overview (Why Essbase?)
Oracle Essbase Technical Overview (OLAP fundamentals, positioning, features and functions, architecture)
Installation Overview (support matrix, pre-requisites, installation guidelines, installation lab overview)
Lab Environment Installs (VMware image copy and decompress, local client installations)
Essbase Client Tools Walk-through and Demonstration (Admin Services [EAS], Essbase Studio [Studio], Essbase Studio [EST], Smartview)
Block Storage Option (BSO) Overview (concepts, design considerations, use cases, Essbase Studio lab overview)
Build BSO cube using Essbase Studio Lab (create OLAP ModellMetaoutline, create cube, view data using Excel add-in and Smartview)
Day 2
Questions & Answers l Day 1 Review
Aggregate Storage Option (ASO) Overview (concepts, design considerations, use cases, lab overview)
Build ASO cube using EAS Lab (create ApplDB, Date-Time wizard, Load Rules, MDX formulas, aggregate views)
Partitioning Overview (concepts, types and use cases, lab overview)
Design and Construct Partition Lab (partition ASO & BSO cubes, validate data)
Essbase Calculations Overview (BSO scripting language)
Calc Scripts Lab (using @ALLOCATE & @TREND functions, validate data)
Tuning and Optimization Overview (design concepts, types of optimizations)
Tuning and Optimization Lab (monitor queries, reset caches, restructure cube)
Security Overview (Shared Services security, ApplDB, UserlGroup, & Filters, lab overview)
Security exercise (create group, user and filter, validate data)
Day 3
Questions & Answers l Day 2 Review
Essbase 11, Fusion Edition (what's new)
Essbase Integration Services (building a cube from a relational source) The old way!
Essbase 11 Lab (text measures, varying attributes, archive and restore, transaction replay)
Essbase l Oracle Business Intelligence EE Integration Overview
OBIEE Demonstration (import Essbase data source, query Essbase, build a cube with OBIEE as a source)
Wrap up and Evaluations
The labs will be delivered on HUB Infrastructure with usage of students notebooks, so students should come to the training with their own notebooks, which should have the following capabilities:
Hardware
Software
|
|
|