Oracle Essbase 11 Certified Implementation Specialist OPN Certified Specialist

Oracle Essbase 11 Essentials

New! Take this exam for FREE! Just register for the Test Fest @OPN Central and book your seat now!

Oracle Essbase 11 Essentials (1Z0-531) exam tests your training and experience to ensure that you have a strong foundation and expertise in Oracle Essbase. The exam targets the intermediate-level implementation team member. Up-to-date training and field experience are recommended.

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. This certification helps their companies qualify for the Oracle Essbase Specialization.


Exam
Number:
1Z0-531
Duration:
105 Minutes
Associated Certifications:
Oracle Essbase 11 Certified Implementation Specialist

OPN Certified Specialist
Number
of Questions:
69
Exam Price:
US $245

Pricing may vary slightly by country or by localized currency. Check Pearson VUE'€™s website for exact pricing in your country.

More on exam pricing
Passing
Score:
62%

Passing score subject to change. View Details.
Click Here to Register:
Register

 

Recommended Training Additional Information & Resources Exam Topics Fraudulent Activity Policy

Recommended Training
Oracle Essbase 11 Essentials – Exam Study Guide (PDF)
OPN Guided Learning Path
Oracle Essbase Implementation Specialist

 

Additional Information & Resources
Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)
More Training Opportunities for Oracle Partners

 

Exam 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 optimize block storage databases
  • Describe and implement block storage design best practices
  • Describe BSO load techniques

Working with Calculation 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 Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.

 
 E-mail this page  Printer View