hyperion essbase 9.3.1 deploy aggregate storage databases

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

application developers
business analysts
business intelligence developer
database designers
developer
database administrators

prerequisites

required prerequisites:

knowledge of microsoft windows
familiarity with essbase administration services console
working knowledge of block storage databases
hyperion essbase fundamentals, hyperion essbase bootcamp, or equivalent experience

suggested prerequisites:

hyperion essbase analytics 9.3.1 bootcamp

course objectives

differentiate between block storage and aggregate storage databases
create aggregate storage databases
perform management tasks for aggregate storage databases
partition block and aggregate storage databases
create member formulas with mdx
build time intelligent outlines

course outline and topics

essbase overview:

hyperion business performance management overview
hyperion analytic solution
data analysis needs
aggregate storage overview

creating aggregate storage databases:

aggregate storage outline hierarchies
designing hierarchies
converting block storage to aggregate storage

loading and aggregating data:

loading aggregate storage data
data aggregation
designing and running aggregations

managing aggregate storage databases:

managing5?spaces
exporting data
data compression
optimizing aggregate storage cache
managing outline paging
disk space management
backing up aggregate storage applications
aggregate storage database statistics

partitioning overview:

partition types
partition overlaps
partition design choices

creating database partitions:p

outline differences
creating partitions
aggregate storage partition designs
creating partitions for write-back
design considerations

creating basic mdx queries:

mdx overview
mdx queries
adding comments to queries
identifying dimensions and members
selecting multiple members
mdx data model: tuples and sets
managing multiple sets

converting block storage member formulas to mdx:

elements common to block storage and mdx formulas
elements unique to mdx formulas
function return types
formula conversion
aggregate storage calculation order
block storage custom functions and macros

creating basic mdx member formulas:

member formula editor
mdx help documentation
formula design considerations
arithmetic operators and expressions
outline layer reference functions
creating mix calculations
deriving variances

time intelligence overview:

time intelligence wizard
building time dimensions based on standard calendar templates
member date ranges

loading data mapped to dates:

time-based data loads
processing load files

using linked attributes for time period reporting:

linked attributes overview
time period reporting

employing mdx date functions:

mdx date functions overview
performing date mathematics with mdx date functions

creating time balance calculations:

time balance tags
flow tags
adding time balance tags to your database outline ...''

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 hyperion essbase 9.3.1 deploy aggregate storage databases 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 for System Administrators
Hyperion Essbase Analytics 9.3.1 Calculate Databases
Hyperion Essbase Analytics 9.3.1 Bootcamp
oracle essbase studio 11.1.1 create and manage data structures

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.