Oracle Essbase

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 behaviour for various ASO data structures
  • Describe calculation script behaviour 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
    Footer Sidebar 7
    Curabitur quis tempus ipsum. Vivamus tincidunt sollicitudin facilisis. Phasellus elementum tortor eu magna tincidunt lacinia. Nullam ac nulla vel enim molestie luctus. In et tempus purus, ac tempor metus. Vestibulum quis semper lorem, sed tempus turpis. Cras lobortis erat ipsum, sed venenatis lacus blandit eget. Mauris sed pharetra felis, ut fringilla odio. Phasellus vitae libero ut lectus sagittis porttitor.

    Etiam magna arcu, ullamcorper ut pulvinar et, ornare sit amet ligula. Aliquam vitae bibendum lorem. Cras id dui lectus. Pellentesque nec felis tristique urna lacinia sollicitudin ac ac ex. Maecenas mattis faucibus condimentum. Curabitur imperdiet felis at est posuere bibendum. Sed quis nulla tellus.

    ADDRESS

    63739 street lorem ipsum City, Country

    PHONE

    +12 (0) 345 678 9

    EMAIL

    info@company.com

    Cart
    Quick Enquiry
    Thank You. We will contact you as soon as possible.