oracle essbase studio 11.1.1 create and manage data structures

reportsource education centre
london, london, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' duration

3 days

audience

business intelligence developer
application developers

prerequisites

required prerequisites:

working knowledge of essbase
familiarity with dimensional data modeling and data warehousing
familiarity with relational database concepts and sql

suggested prerequisites:

oracle essbase 11.1.1: bootcamp
hyperion essbase 9.3.1: deploy aggregate storage databases

course objectives

create logical star schema data marts from e-r dimensional database schemas and flat files
build metadata elements, hierarchies, schemas, and cube models
load dimension members and data to essbase
define drill-through reports to relational5?s
describe essbase studio architecture
describe the essbase studio implementation process

course outline and topics

data warehousing and business intelligence:

business challenges
business information analysis
business intelligence (bi)
enterprise performance management (epm)
data warehousing
hyperion epm and data warehousing
essbase studio and data warehousing

essbase studio deployment architecture:

essbase studio architecture
essbase studio client overview
essbase studio directory structure
essbase studio properties files
essbase studio catalog
essbase studio help files

data source connections:

defining connection parameters
creating connections to relational, dimension server, and text data sources
working with data source connections
creating connections with connection wizard
using introspection
defining minischemas

metadata elements and alias sets:

creating metadata elements
working with metadata elements
creating folders to organize your metadata elements
creating and working with alias sets

working with minischemas:

creating minischemas
managing minischemas (open/view/save/set properties/refresh)
creating logical objects
adding and deleting joins between5?s
viewing sample data from5?s or individual columns

hierarchies:

creating standard hierarchies
creating measures hierarchies
creating specialized hierarchies
creating calendar hierarchies
defining consolidation levels

cube schemas:

building cube schemas with cube schema wizard
choosing measures and hierarchies for a cube schema
setting cube schema options
defining data load mappings
creating essbase models from existing cube schemas

essbase models:

setting model-level properties
modeling standard attributes
modeling varying attributes
setting member properties
performing alias mapping
adjusting hierarchy build settings
modifying transformation settings
mapping properties to database columns

deploying cubes and applications:

deploying cubes using cube deployment wizard
setting load options for deploying cubes
creating and saving a rules file
performing a “lights out�deployment
modifying essbase model properties
managing deployed applications

drill through reporting:

creating drill-through reports
associating reports for drill-through
associating drill-through with essbase models
setting query governors
testing functionality during report design
utilizing drill-through reporting in smart view

lineage:

opening lineage viewer
navigating through the lineage
viewing the history of an element
launching administration services console from lineage viewer
editing element properties
editing essbase model properties
showing deployment history
viewing sample data ...''

Elements of this syllabus are subject to change.

Phone:0207 614 8050

School Address/Venue(s):

reportsource
4 broadgate


Jobs & Resumes: london
Houses & Roommates: london
Travel Agencies: london

Search other schools for oracle essbase studio 11.1.1 create and manage data structures training resources.

Crystal Ball 11.1.1 Essentials
Hyperion Data Integration Management 9.3 Integrate Enterprise Data
hyperion data relationship management 9.3.1 administration
hyperion essbase 9.3.1 deploy aggregate storage databases
Hyperion Essbase 9.3.1 for System Administrators
Hyperion Essbase Analytics 9.3.1 Calculate Databases
Hyperion Essbase Analytics 9.3.1 Bootcamp

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.