You are previewing Oracle Essbase 11 Development Cookbook.
O'Reilly logo
Oracle Essbase 11 Development Cookbook

Book Description

Over 90 advanced development recipes to build and take your Oracle Essbase Applications further with this Oracle Essbase

  • This book and e-book will provide you with the tools needed to successfully build and deploy your Essbase application.

  • Includes the major components that need to be considered when designing an Essbase application.

  • This book can be used to build calculations, design process automation, add security, integrate data, and report off an Essbase cube.

In Detail

Oracle Essbase is a Multi-Dimensional Online Analytical Processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. Oracle Essbase enables business users to quickly model complex business scenarios.

This practical cookbook shows you the advanced development techniques when building Essbase Applications and how to take these applications further.

Packed with over 90 task-based and immediately reusable recipes, this book starts by showing you how to use a relational data model to build and load an Essbase cube and how to create a data source, prepare the mini schema, and work with the data elements in Essbase Studio. The book then dives into topics such as building the BSO cube, building the ASO cube, using EAS for development, creating Calculation Scripts and using MaxL to automate processes.

Table of Contents

  1. Oracle Essbase 11 Development Cookbook
    1. Oracle Essbase 11 Development Cookbook
    2. Credits
    3. About the Author
    4. About the Reviewer
    5. www.PacktPub.com
        1. Support files, eBooks, discount offers, and more
          1. Why Subscribe?
          2. Free Access for Packt account holders
        2. Instant Updates on New Packt Books
    6. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Errata
        3. Piracy
        4. Questions
    7. 1. Understanding and Modifying Data Sources
      1. Introduction
      2. Setting up an Account or Measures dimension with a parent-child reference
        1. Getting ready
        2. How to do it...
          1. How it works...
          2. There's more...
          3. See also
      3. Setting up dimensions with a generation reference
        1. Getting ready
        2. How to do it...
          1. How it works...
          2. See also
      4. Adding columns for outline formulas
        1. Getting ready
        2. How to do it...
          1. How it works...
      5. Adding the solve order column to tables that have ASO formulas
        1. Getting ready
        2. How to do it...
          1. How it works...
      6. Adding and populating the Sort Order Column
        1. Getting ready
        2. How to do it...
          1. How it works...
          2. See also
      7. Adding tables for varying attributes
        1. Getting ready
        2. How to do it...
          1. How it works...
          2. See also
      8. Determining hierarchies in relational tables
        1. Getting ready
        2. How to do it...
          1. How it works...
          2. There's more...
          3. See also
      9. Using the Essbase Outline Extractor to extract dimensions
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
      10. Using Star Analytics to build your star schema from existing Essbase cubes
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
    8. 2. Using Essbase Studio
      1. Introduction
          1. Advantages of Essbase Studio
          2. Disadvantage of Essbase Studio
      2. Creating TBC sample database and connecting to the data source
        1. Getting ready
        2. How to do it...
        3. How it works...
      3. Adding user-defined tables
        1. Getting ready
        2. How to do it...
        3. How it works...
      4. Building your minischema
        1. Getting ready
        2. How to do it…
        3. How it works...
        4. See also
      5. Setting up joins in a minischema
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There’s more…
        5. See also
      6. Adding tables to a minischema
        1. Getting ready
        2. How to do it…
        3. How it works…
        4. See also
      7. Using a text file data source
        1. Getting ready
        2. How to do it…
        3. How it works…
      8. Working with Common Platform Language (CPL)
        1. Getting ready
        2. How to do it…
        3. How it works…
      9. Using Sort Order on data elements
        1. Getting ready
        2. How to do it…
        3. How it works...
    9. 3. Building the BSO Cube
      1. Introduction
      2. Creating hierarchies using a parent-child reference table
        1. Getting ready
        2. How to do it…
        3. How it works…
        4. See also
      3. Creating hierarchies using a generation reference table
        1. Getting ready
        2. How to do it…
        3. How it works…
      4. Adding attribute dimensions to hierarchies
        1. Getting ready
        2. How to do it…
        3. How it works…
        4. See also...
      5. Building a Calendar dimension
        1. Getting ready
        2. How to do it…
        3. How it works...
      6. Creating date elements
        1. Getting ready
        2. How to do it…
        3. How it works...
      7. Creating Alias tables
        1. Getting ready
        2. How to do it…
        3. How it works...
        4. There's more...
      8. Developing cube schema and an Essbase model
        1. Getting ready
        2. How to do it…
        3. How it works...
        4. There's more...
        5. See also
      9. Setting Essbase properties
        1. Getting ready
        2. How to do it…
        3. How it works...
      10. Deploying a cube
        1. Getting ready
        2. How to do it…
        3. How it works...
      11. Creating an OLAP Model in EIS
        1. Getting ready
        2. How to do it…
        3. How it works...
      12. Creating an OLAP metaoutline in EIS
        1. Getting ready
        2. How to do it…
        3. How it works...
    10. 4. Building the ASO Cube
      1. Introduction
      2. Using the Connection Wizard to set up an ASO cube
        1. Getting ready
        2. How to do it...
        3. How it works...
      3. Building a Measures dimension from the fact table
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      4. Creating an ASO Cube Schema and an Essbase Model
        1. Getting ready
        2. How to do it...
        3. How it works...
      5. Understanding Essbase Model properties for the ASO cube
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      6. Designing a drill-through report
        1. Getting ready
        2. How to do it...
        3. How it works
        4. There's more
      7. Using the View dimension for Dynamic Time Series reporting
        1. Getting ready
        2. How to do it...
        3. How it works
    11. 5. Using EAS for Development
      1. Introduction
      2. Adding an application and database on an Essbase Server
        1. Getting ready
        2. How to do it...
        3. How it works...
      3. Using the outline editor to add dimensions
        1. Getting ready
        2. How to do it...
        3. How it works...
      4. Using dimension build rules to add the parent-child dimension
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      5. Creating dimension build rules to add a base and attribute dimensions
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      6. Using dimension build rules to add user-defined attributes and associate dimensions
        1. Getting ready
        2. How to do it...
        3. How it works...
      7. Creating load rules for flat file data loads
        1. Getting ready
        2. How to do it...
        3. How it works...
      8. Creating substitution variables
        1. Getting ready
        2. How it works...
        3. There's more...
        4. There's more...
        5. See also
      9. Using If/Else logic and substitution variables in outline formulas
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      10. Using Text measures on a BSO cube
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      11. Using Date measures on a BSO cube
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      12. Using different outline formula logic at parent level
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      13. Creating a load rule for SQL data load using substitution variables
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      14. Using MDX in aggregate storage applications
        1. Getting ready
        2. How to do it...
        3. How it works...
    12. 6. Creating Calculation Scripts
      1. Introduction
      2. Using Essbase Set function commands and Calc All to calculate cubes
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      3. Using control flow commands, conditional, and logical operators
        1. Getting ready
        2. How to do it...
        3. How it works
        4. See also
      4. Using substitution variables in calculations script
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      5. Using UDAs and Calc Two Pass in calculation scripts
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
        5. See also
      6. Using Attributes in calculation scripts
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      7. Clearing data and using the cross- dimensional operators in a calculation script
        1. Getting ready
        2. How to do it...
        3. How it works
        4. See also
      8. Using allocation functions in calculation scripts
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      9. Modifying Essbase settings to improve calculation performance
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      10. Using MDX to calculate Aggregate Storage database
        1. Getting ready
        2. How to do it...
        3. How it works...
    13. 7. Using MaxL to Automate Process
      1. Introduction
      2. Setting up folder structure and other files needed for MaxL automation
        1. Getting ready
        2. How to do it...
        3. How it works
        4. There's more...
      3. Executing dimension build rules using MaxL
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      4. Executing load rules using MaxL
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      5. Executing calculations using MaxL
        1. Getting ready
        2. How to do it...
        3. How it works...
      6. Executing partitions using MaxL
        1. Getting ready
        2. How to do it...
        3. How it works...
      7. Executing report scripts using MaxL
        1. Getting ready
        2. How to do it...
        3. How it works...
      8. Adding or changing substitution variables with MaxL
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      9. Using ASO incremental data loads
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. There's more...
      10. Using encryption in MaxL scripts
        1. Getting ready
        2. How to do it...
        3. How it works...
      11. Deploy dimension created in Essbase Studio
        1. Getting ready
        2. How to do it...
        3. How it works...
    14. 8. Data Integration
      1. Introduction
      2. Using report script to extract data to a text file
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      3. Using the DATAEXPORT function to extract data into a text file
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      4. Using the DATAEXPORT function to extract data into a relational source
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      5. Exporting data using column format
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      6. Using MaxL to extract the outline in XML format
        1. Getting ready
        2. How to do it...
        3. How it works...
      7. Using @XREF functions to move data between BSO cubes
        1. Getting ready
        2. How to do it...
        3. How it works...
      8. Partitioning data from BSO to ASO cubes
        1. Getting ready
        2. How to do it...
        3. How it works...
      9. Using MDX for extracting data using API
        1. Getting ready
        2. How to do it...
        3. How it works...
      10. There's more...
    15. 9. Provisioning Security Using MaxL Editor or Shared Services
      1. Introduction
      2. Using MaxL editor to add and externalize a user
        1. Getting ready
        2. How to do it...
        3. How it works
        4. There's more...
      3. Using Shared Services to add and provision a user
        1. Getting ready
        2. How to do it...
        3. How it works...
      4. Using MaxL Editor to set up a filter for MetaRead and Write access
        1. Getting ready
        2. How to do it...
        3. How it works...
      5. Using Shared Services to provision filters to a group
        1. Getting ready
        2. How to do it...
        3. How it works...
      6. Using Shared Services to provision calculation scripts to a group
        1. Getting ready
        2. How to do it...
        3. How it works...
      7. Using MaxL to export security file
        1. Getting ready
        2. How to do it...
        3. How it works...
    16. 10. Developing Dynamic Reports
      1. Introduction
      2. Creating a connection and using substitution variables in financial reports
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      3. Using the column templates and formatting reports
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      4. Retrieving data using UDAs and Attributes
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      5. Retrieving data using children and descendants member set functions
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      6. Using User Prompts and the POV to select members
        1. Getting ready
        2. How to do it...
        3. How it works...
        4. See also
      7. Using conditional formatting and suppression in financial reports
        1. Getting ready
        2. How to do it...
        3. How it works...
      8. Adding related content to financial reports
        1. Getting ready
        2. How to do it...
        3. How it works...
      9. Creating a web analysis report
        1. Getting ready
        2. How to do it...
        3. How it works...