1Z0-531: Oracle Essbase 11 Essentials

Exam Number: 1Z0-531

Exam Title: Oracle Essbase 11 Essentials

Associated Certification Paths

Oracle 1Z0-851 Certification Details:

Exam Name Oracle Essbase 11 Essentials
Exam Code 1Z0-531
Exam Product Version Oracle Essbase
Exam Price USD $245
Duration 105 minutes
Number of Questions 69
Passing Score 62% 
Validated Against This exam has been validated against Oracle Essbase
Format Multiple Choice
Recommended Practice 1Z0-531 Online Practice Exam
Recommended Training Oracle Essbase 11.1.2: Calculate Block Storage Databases (

Oracle 1Z0-531 Certification Topics:

Overview of Oracle Essbase
  • Describe multidimensional analysis
  • Describe Oracle Essbase
Smart View
  • Describe Smart View
  • Retrieve Data using Smart View
Essbase Application Creation Fundamentals
  • Perform manual outline creation
  • Build dimensions from sources
  • Perform initial data loads
  • Use calculations and aggregations
  • Assign security
Aggregate Storage Databases
  • Describe when to deploy aggregate storage, block storage, or a combined solution
  • Convert block storage to aggregate storage
  • Create, load, and pre-aggregate aggregate storage databases
  • Employ database partitioning in combined block/aggregate storage solutions
  • Write member formulas using MDX
  • Perform management tasks for aggregate storage databases
  • Partition block and aggregate storage databases
  • Describe and implement aggregate storage design best practices
  • Describe multiple hierarchies and the use of Shared Members
Block Storage Databases
  • Describe block storage calculations
  • Describe the default database calculation order
  • Describe data blocks
  • Describe how data blocks are indexed
  • Interpret database statistics
  • Describe when data blocks are created
  • Describe the block storage database calculation process
  • Tune and optimaize block storage databases
  • Describe and implement block storage design best practices
  • Describe BSO load techniques
Working with Caluculation Scripts
  • Identify correct and incorrect calculation script syntax
  • Describe calculation script behavior for various ASO data structures
  • Describe calculation script behavior for various BSO data structures
  • Design calculation scripts to meet specified requirements
Essbase Administration
  • Describe the file Essbase.cfg and its settings.
  • Describe the file Essbase.sec and its settings.
  • Identify and interpret Essbase log files
  • Manage Essbase security via Administration Services
  • Manage Essbase security via Shared Services
  • Back up and recover Block Storage Databases
  • Automate database processes with MaxL
  • Describe and use substitution variables and location aliases
Essbase Studio
  • Describe functionality of Essbase studio
  • Add and delete joins between tables
  • Create drill through reports

Oracle 1Z0-531 - Oracle Essbase 11 Essentials Exam Preparation: