Table of Contents

• Title and Copyright Information
• Accessibility and Support
• 1 Case Study: Designing a Single-Server, Multidimensional Database
  • Process for Designing a Database
  • Case Study: The Beverage Company
  • Analyze and Plan the Essbase Application
    • Analyze Source Data
    • Identify User Requirements
    • Plan for Security in a Multiple User Environment
    • Create Database Models
      • Identify Analysis Objectives
      • Determine Dimensions and Members
      • Analyze Database Design
  • Draft an Essbase Outline
    • Dimension Types
    • Member Storage Properties
    • Design an Outline to Optimize Performance
  • Load Test Data
  • Define Essbase Calculations
    • Consolidation of Dimensions and Members
    • Tags and Operators on Example Measures Dimension
    • Accounts Dimension Calculations
    • Formulas and Functions
    • Dynamic Calculations
    • Two-Pass Calculations
    • Checklist for Calculations
  • Define Reports
  • Verify the Design
• 2 Overview of Multidimensional Databases
  • OLAP and Multidimensional Databases
  • Dimensions and Members
    • Outline Hierarchies
    • Dimension and Member Relationships
      • Parents, Children, and Siblings
      • Descendants and Ancestors
      • Roots and Leaves
      • Generations and Levels
    • Hierarchy Shapes
    • Standard Dimensions and Attribute Dimensions
    • Sparse and Dense Dimensions
    • Selection of Dense and Sparse Dimensions
      • Dense-Sparse Configuration for Sample.Basic
      • Dense and Sparse Selection Scenarios
  • Data Storage
    • Data Values
    • Data Blocks and the Index System
    • Slices: Multiple Data Views
  • The Essbase Solution for Creating Optimized Databases
• 3 About Applications and Databases
  • Essbase Database Artifacts
    • Purpose and Location of Database Outline
    • Source Data for Essbase
    • Rule Files for Data Load and Dimension Build
    • About Calculation Scripts
  • Create an Application and Database
  • Implement Variables for Changing Information
    • Allowed Substitution Variable Names and Values
    • Create or Set Substitution Variables
    • Remove Substitution Variables
    • Update Substitution Variables
• 4 Work with Essbase Outlines
  • Process for Creating Outlines
  • Ways to Edit Outlines
  • Outline Locks
  • Set the Dimension Storage Type
  • Move and Compare Dimensions and Members
  • Sort Members in the Essbase Outline
  • Verify Outlines
  • Save Outlines
  • Duplicate Member Names in Outlines
• 5 Dimension and Member Properties
  • Dimension Types
    • Time Dimension type
    • Accounts Dimension type
      • Time Balance Properties
      • Skip Properties for Time Balance
      • Variance Reporting Properties
    • Attribute Dimension type
  • Examples of Member Consolidation
    • Member Consolidation Properties
    • Operation Results on #MISSING and Zero Values
  • Options for How Members Store Data Values
    • Stored Members
    • Dynamic Calculation Members
    • Label Only Members
    • Shared Members
      • Guidelines for Shared Members
      • Shared Member Retrieval During Drill-Down
      • Implied Shared Members
  • Set Aliases
    • Create Aliases
    • Work With Aliases and Alias Tables
  • Two-Pass Calculation Property
  • Create Formulas
  • Add or Update Generation and Level Names
  • Create UDAs
  • Add Comments to Dimensions and Members
  • Member IDs
• 6 Work with Essbase Attributes
  • Process for Implementing Attributes
  • Benefits of Essbase Attributes
  • Overview of Attribute Dimensions
    • Members of Attribute Dimensions
    • Restrictions for Base and Attribute Dimensions and Members
    • Restrictions for Attribute Dimension Association
    • Restrictions for Attribute Member Association
    • Attribute Types
    • Comparison of Attribute and Standard Dimensions
    • Solve Order and Attributes
    • Two-Pass Calculations on Attribute Dimensions
    • Comparison of Attributes and UDAs
  • Build Attribute Dimensions
  • Set Member Names in Attribute Dimensions
    • Set Prefix and Suffix Formats for Member Names of Attribute Dimensions
    • Set Boolean Attribute Member Names
    • Change the Member Names in Date Attribute Dimensions
    • Set Up Member Names Representing Ranges of Values
    • Change the Member Names of the Attribute Calculations Dimension
  • Calculate Attribute Data
    • Attribute Calculations Dimension
    • Default Members of the Attribute Calculations Dimension
    • Attribute Calculation Example
    • Access Attribute Calculations Members in Smart View
    • Attribute Calculation and Retrieval Performance
    • Attributes in Calculation Formulas
    • Attribute Calculation and Shared Members
    • Differences Between Calculating Attribute and Non-Attribute Members
  • Optimize Outline Performance with Attributes
  • Non-Aggregating Attributes
  • Submit Data for Valid Attribute Combinations in the Grid
  • Suppress Invalid Attribute Combinations in the Grid
• 7 Typed Measures
  • About Typed Measures
  • Work with Text Measures
    • Text Measures Workflow
    • Text List Objects
  • Date Measures
    • Implement Date Measures
    • Functions Supporting Date Measures
  • Database Operations on Text and Date Measures
    • Load, Clear, and Export Text and Date Measures
    • Consolidation Factors for Text and Date Measures
    • Query on Data with Text and Date Measures
    • Limitations of Text and Date Measures
  • Format Strings
    • Implement Format Strings
    • MDX Format Directive
    • Functions Supporting Format Strings
• 8 Design and Build Currency Conversion Applications
  • About the Sample Currency Application
  • Structure of Currency Applications
  • Conversion Methods
  • Build Currency Conversion Applications and Perform Conversions
• 9 Design Partitioned Applications
  • Overview of Partitioning
    • Partition Types
    • Parts of a Partition
    • Partition Data Sources and Targets
    • Attributes in Essbase Partitions
    • Version and Encoding Requirements
  • Partition Design Requirements
    • Benefits of Partitioning
    • Partitioning Strategies
    • Decision Factors for Partitioning a Database
    • Considerations for Partitioning Data
    • Security for Partitioned Databases
  • Replicated Partitions
  • Transparent Partitions
• 10 Create and Maintain Partitions
  • Choose a Partition Type
  • Set up a Partition Source of Data
  • Set the Partition User Name and Password
  • Define a Partition Area
  • Map Members in Partitions
    • Map Members with Different Names
    • Map Cubes with Extra Dimensions
    • Map Shared Members
    • Map Attributes Associated with Members
    • Create Advanced Area-Specific Mappings
  • Validate Partitions
  • Populate or Update Replicated Partitions
  • View Partition Information
  • Partitioning and TLS/SSL
  • Troubleshoot Partitions
• 11 Overview of Data Load and Dimension Build
  • Data Load and Dimension Build Workflow
  • Sources of Data
    • Items in a Source of Data
      • Valid Dimension Fields
      • Valid Member Fields
      • Valid Data Fields
      • Valid Delimiters
      • Valid Formatting Characters
    • Supported Source Data Types
  • Load Rules
  • Situations that Do and Do Not Need a Load Rule
  • Sources of Data that Do Not Need a Load Rule
    • Ranges of Member Fields in the Source Data
    • Columns in the Source Data
  • Security and Multiple-User Considerations
• 12 Design Rules for Data Load or Dimension Build
  • General Process for Creating Rules
  • Generate Load Rules with Application Workbooks
  • Define Load Rules in Essbase Web Interface
    • Access and Edit Rules
    • Create New Dimension Build Rule
    • Create New Data Load Rule
    • Set File Delimiters
    • Set Dimension Build Field Type Information
    • Select a Build Method
    • Set Dimension Build Operational Instructions
    • Set Dimension Build Global Properties and General Source Properties
    • Use the Source Data to Work with Member Properties
    • Define Data Load Field Properties
    • Perform Operations on Records
      • Select and Reject Records
      • Set the Records Displayed
      • Handle Header Records
    • Perform Operations on Fields
      • Ignore Fields
      • Ignore Strings
      • Move Fields
      • Add Fields
      • Join Fields
      • Create Field with Join
      • Split Fields
      • Copy Fields
      • Map Fields
      • Change Field Names
    • Perform Operations on Data
      • Data Fields in the Load Rule
      • Add to or Subtract from Existing Values
      • Extract Source Data Using Column Store Options
      • Clear Existing Data Values During Data Load
      • Replace All Data
      • Scale Data Values
      • Flip Field Signs
    • Validate Rules
      • Requirements for Valid Data Load Rule Files
      • Requirements for Valid Dimension Build Rule Files
  • Define Rules that Query External Sources
    • Pull and Push Methods of Loading External Data into Essbase
    • Overview of SQL Properties in Rules
    • Connection Strings for SQL-Based Connectivity
    • Access External Data Using a Connection and Datasource
    • Access Oracle Database Using Oracle Call Interface
    • Access Data Using ODBC Connectivity
      • Configure the ODBC Source of Data (Linux)
      • Configure the ODBC Source of Data (Windows)
      • Customize the Rule File for an ODBC Source of Data
      • Special SQL Configuration Options
    • Access Data Using JDBC Connectivity
    • Stream from a Remote Database
  • Export Load Rules for Offline Editing
• 13 Perform and Debug Data Loads or Dimension Builds
  • Perform Data Loads or Dimension Builds
  • Build Dimensions and Load Data by Streaming from a Remote Database
  • Terminate Data Loads or Dimension Builds
  • Tips for Loading Data and Building Dimensions
    • Incremental Dimension Builds
    • Where to Load Data
    • Missing Fields in the Source Data
    • Load a Subset of Records from the Source
  • Debug Data Loads and Dimension Builds
    • Verify that Essbase Server Is Available
    • Verify that the Source Data Is Available
    • Check Error Logs
    • Resolve Problems with Data Loaded Incorrectly
    • Create Rejection Criteria for End of File Markers
    • How Essbase Processes a Load Rule
    • How Essbase Processes Missing or Invalid Fields During a Data Load
    • Load from Dimension Build and Data Load Error Logs
• 14 Dimension Build Examples
  • Dimension Build Methods
  • Generation References in Dimension Builds
  • Level References in Dimension Builds
  • Parent-Child References in Dimension Builds
  • Add a List of New Members
    • Add Members Based On String Matches
    • Add Members as Siblings of the Lowest Level
    • Add Members to a Specified Parent
  • Build Attribute Dimensions and Associate Attributes
    • Build Attribute Dimensions
    • Associate Attributes in a Dimension Build
    • Numeric Range Attributes
      • Build Attribute Dimensions that Accommodate Ranges
      • Associate Base Dimension Members with Their Range Attributes
      • Ensure the Validity of Associations
    • Checklist for Building Attribute and Base Dimensions
  • Build Shared Members
    • Build Shared Members at the Same Generation
      • Use Generation References to Create Same Generation Shared Members
      • Use Level References to Create Same Generation Shared Members
      • Use Parent-Child References to Create Same Generation Shared Members
    • Build Shared Members at Different Generations
      • Use Parent-Child References to Create Different Generation Shared Members
      • Use Level References to Create Different Generation Shared Members
    • Build Shared Non-Level 0 Members
    • Build Multiple Roll-Ups by Using Level References
    • Build Shared Roll-Ups from Multiple Data Sources
  • Build Duplicate Member Outlines
    • Uniquely Identify Members Through the Load Rule
    • Build Qualified Member Names Using the Load Rule
• 15 Modeling Data in Private Scenarios
• 16 Calculate Essbase Block Storage Databases
  • About Block Storage Calculation
    • Outline Calculation
    • Calculation Script Calculation
  • Multidimensional Calculation Concepts
  • Set the Default Calculation
  • Calculate a Block Storage Database
  • Parallel and Serial Calculation
  • Cross Reference Another Database with Location Alias
• 17 Develop Formulas for Block Storage Cubes
  • Implement Essbase Formulas and Formula Calculations
  • Essbase Formula Syntax
    • Operators
    • Dimension and Member Names
    • Constant Values
    • Nonconstant Values
    • Basic Equations
    • Validation of Formula Syntax
  • Use Functions in Formulas
    • Conditional Tests
    • Examples of Conditional Tests
    • Mathematical Operations
    • Member Relationship Functions
    • Range Functions
    • Financial Functions
    • Member-Related Functions
      • Specify Member Lists and Ranges
      • Generate Member Lists
      • Manipulate Member Names
      • Work with Member Combinations Across Dimensions
    • Value-Related Functions
      • Interdependent Values
      • Variances Between Actual and Budget Values
      • Functions that Allocate Values
    • Forecasting Functions
    • Statistical Functions
    • Date and Time Function
    • Calculation Mode Function
  • Use Substitution Variables in Formulas
  • Use Formulas on Partitions
  • Display Formulas
• 18 Formula Examples for Block Storage Databases
  • Calculate Period-to-Date Values in an Accounts Dimension
  • Calculate Rolling Values
  • Calculate Monthly Asset Movements
  • Test for #MISSING Values
  • Calculate an Attribute Formula
• 19 Block Storage Database Calculation Order
  • Data Storage in Data Blocks
  • Member Calculation Order
    • Calculation Effects of Member Relationships
    • How Members Consolidate
    • Order of Dimensions in the Database Outline
      • Formulas on Members in the Database Outline
      • Use of the Calculation Operators *, /, and %
    • Avoid Forward Calculation References
  • Block Calculation Order
  • Data Block Renumbering
  • Cell Calculation Order
    • Cell Calculation Order: Example 1
    • Cell Calculation Order: Example 2
    • Cell Calculation Order: Example 3
    • Cell Calculation Order: Example 4
    • Cell Calculation Order for Formulas on a Dense Dimension
  • Calculation Passes
  • Calculation of Shared Members
• 20 Intelligent Calculation for Block Storage Cubes
  • Ways to Use Intelligent Calculation
    • Turn Intelligent Calculation On or Off
    • Intelligent Calculation for a Default, Full Calculation
    • Intelligent Calculation for a Calculation Script, Partial Calculation
  • Intelligent Calculation and Data Block Status
  • The SET CLEARUPDATESTATUS Command
  • Intelligent Calculation of Data Blocks
    • Intelligent Calculation of Dense Dimensions
    • Intelligent Calculation of Sparse Dimensions
    • Intelligent Calculation and Concurrent Calculations
    • Intelligent Calculation and Multiple-Pass Calculations
    • Examples and Solutions for Multiple-Pass Calculations
  • Examples with SET CLEARUPDATESTATUS
  • Effects of Intelligent Calculation
    • Changed Formulas and Accounts Properties: Impact on Block Status
    • Relationship and Financial Functions: Impact on Block Status
    • Database Restructure: Impact on Block Status
    • Data Copy and Clear: Impact on Block Status
    • Currency Conversion: Impact on Block Status
  • Limitations of Intelligent Calculation
  • Considerations for Intelligent Calculation on Oracle Exalytics In-Memory Machine
• 21 Dynamic Calculation of Data Values
  • Which Values to Calculate Dynamically
    • Dense Members and Dynamic Calculation
    • Sparse Members and Dynamic Calculation
    • Parent-Child Relationships and Dynamic Calculation
    • Calculation Scripts and Dynamic Calculation
    • Formulas and Dynamically Calculated Members
    • Scripts and Dynamically Calculated Members
  • How Dynamic Calculation Changes Calculation Order
    • Calculation Order for Dynamic Calculation
    • Calculation Order for Dynamically Calculating Two-Pass Members
    • Calculation Order for Asymmetric Data
    • Solve Order in Hybrid Mode
  • Reduce Dynamic Calc Impact on Retrieval Time
  • Dynamic Calc Restrictions
  • Create Dynamic Calc Members
  • Dynamic Calc and Database Restructuring
  • Dynamically Calculate Data in Partitions
• 22 Calculate Time Series Data
  • Calculate First, Last, and Average Values
    • Specify Accounts and Time Dimensions
    • Report the Last Value for Each Time Period
    • Report the First Value for Each Time Period
    • Report the Average Value for Each Time Period
    • Skip #MISSING and Zero Values in Time Balance Calculations
    • Effects of First, Last, and Average Tags
  • Calculate Period-to-Date Values Using Dynamic Time Series Members
    • Use Dynamic Time Series Members
    • Enable and Disable Dynamic Time Series Members
    • Specify Alias Names for Dynamic Time Series Members
    • Predefined Generation Names for Dynamic Time Series Members
    • Retrieve Period-to-Date Values
    • Optimize Dynamic Time Series Members in Transparent Partitions
• 23 Develop Calculation Scripts for Block Storage Cubes
  • Calculate a Cube with Calculation Scripts
  • Learn Basic Calculation Script Syntax
  • Use Calculation Commands
    • Calculate the Essbase Outline
    • Control the Flow of Calculations
    • Declare Data Variables During Calculation
    • Specify Global Settings for a Calculation
  • Formulas in Calculation Scripts
    • Basic Equations in Essbase Calc Scripts
    • Conditional Equations in Essbase Calc Scripts
    • Interdependent Formulas in Essbase Calc Scripts
    • Calculation Script Formulas and Intelligent Calculation Status
    • Group Formulas and Dimensions in the Script
  • Substitution Variables in Calculation Scripts
  • Runtime Substitution Variables in Calculation Scripts Run in Essbase
    • Hints for Runtime Substitution Variables in Calculation Scripts Run in Essbase
    • Log Runtime Substitution Variables
  • Runtime Substitution Variables in Calculation Scripts Run in Smart View
    • Example: Runtime Substitution Variable Set to POV
    • XML Tag Reference—Calculation Scripts with Runtime Substitution Variables for Smart View
  • Clear and Copy Data
  • Calculate a Subset of Data in the Cube
    • Calculate Lists of Members
    • Use the FIX Command
    • Use the Exclude Command
  • Enable Calculations on Potential Blocks
    • Copy Existing Blocks with DATACOPY
    • Calculate All Potential Blocks with SET CREATENONMISSINGBLK
  • Use Calculation Scripts on Partitions
  • Save, Execute, and Copy Calculation Scripts
  • Check Calculation Results
• 24 Examples of Calculation Scripts for Block Storage Databases
  • Calculate Variance
  • Calculate Database Subsets
  • Load New Budget Values
  • Calculate Product Share and Market Share Values
  • Allocate Costs Across Products
  • Allocate Values within a Dimension
  • Allocate Values Across Multiple Dimensions
  • Goal-Seeking Using the LOOP Command
  • Forecast Future Values
• 25 Use Parallel Calculation
  • FIXPARALLEL Parallel Calculation
  • CALCPARALLEL Parallel Calculation
    • Analysis of Feasibility of CALPARALLEL
    • CALCPARALLEL Parallel Calculation Guidelines
    • Relationship Between CALCPARALLEL Parallel Calculation and Other Essbase Features
    • Check Current CALCPARALLEL Settings
    • Enable CALCPARALLEL Parallel Calculation
    • Identify Additional Tasks for Parallel Calculation
    • Tune CALCPARALLEL with Log Messages
    • Monitor CALCPARALLEL Parallel Calculation
• 26 Develop Custom-Defined Calculation Functions
  • Requirements for Validity of Custom-Defined Functions
  • Create and Compile a Java Class for Custom Defined Functions
  • Install Java Classes on Essbase Server
  • Register Custom-Defined Functions
  • Implement Registered Custom-Defined Functions
  • Update Custom-Defined Functions
  • View Custom-Defined Functions
  • Remove Custom-Defined Functions
  • Copy Custom-Defined Functions
  • Performance Considerations for Custom-Defined Functions
• 27 Develop Custom-Defined Calculation Macros
  • Name Custom-Defined Macros
  • Create Custom-Defined Macros
  • Implement Custom-Defined Macros
  • View Custom-Defined Macros
  • Update Custom-Defined Macros
  • Copy Custom-Defined Macros
  • Remove Custom-Defined Macros
  • Refresh the Catalog of Custom-Defined Macros
• 28 Write MDX Queries
  • Build an MDX Query Template
  • MDX Sets and Tuples
  • MDX Query Layout with Axes and Cube Specification
  • Use MDX Functions to Build Sets
  • Reference Levels and Generations with MDX
  • Use a Slicer Axis to Set MDX Query Point-of-View
  • Common MDX Relationship Functions
  • MDX Functions for Set Operations
  • Reusable Sets and Members: MDX WITH Section
  • Iterative MDX Functions
  • Handle Missing Data with MDX
  • Variables in MDX Queries
  • Query for Properties in MDX
• 29 Export Data
  • Export Data Using MaxL
  • Export Text Data Using Calculation Scripts
• 30 Control Access to Database Cells Using Security Filters
  • Define Permissions Using Security Filters
  • Create Filters
    • Filtering Members Versus Filtering Member Combinations
      • Filter Members Separately
      • Filter Member Combinations
    • Filter Using Substitution Variables
    • Filter with Attribute Functions
    • Metadata Filters
    • Dynamic Filters
      • Dynamic Filter Syntax
      • Workflow to Create Dynamic Filters
      • Example of a Dynamic Filter
  • Manage Filters
  • Assign Filters
    • Overlapping Filter Definitions
    • Overlapping Metadata Filter Definitions
    • Overlapping Access Definitions
• 31 MaxL Data Definition Language
• 32 Optimize Database Restructuring
  • About Database Restructuring
    • Implicit Restructures
    • Explicit Restructures
    • Conditions Affecting Database Restructuring
  • Optimize Restructure Operations
  • Actions That Improve Restructuring Performance
    • Parallel Restructuring
    • Options for Saving a Modified Outline
  • Outline Change Quick Reference
• 33 Optimize Data Loads
  • Stages of Essbase Data Loads
  • Group Sparse Member Combinations
  • Make the Source Data as Small as Possible
  • Make Source Fields as Small as Possible
  • Position Data in the Same Order as the Outline
  • Load Data from Essbase Server
  • Parallel Data Load
• 34 Block Storage Calculation Optimization
  • Design for Calculation Performance
    • Block Size and Block Density
    • Order of Sparse Dimensions
    • Incrementally Loaded Cubes
    • Outlines with Multiple Flat Dimensions
    • Formulas and Calculation Scripts
  • Monitor and Trace Calculations
    • Trace Calculations
    • SET Commands for Calc Testing and Statistics
  • Calculate Selected Tuples
    • Use Case for Tuple Calculation
    • Understand Tuple-Based Calculation
    • Select Tuples for Point of View Calculation
    • Examples of Tuple Selection to Reduce Calculation Scope
      • No Tuple Selection
      • Selection of Named Sparse Dimensions
      • Selection of Contextual Sparse Dimensions
  • Simulate Calculations to Estimate Calculation Time
    • Simulate a Calculation
    • Estimate Calculation Time
    • Factors Affecting Estimate Accuracy
    • Changing the Outline Based on Results
  • Estimate Calculation Effects on Cube Size
  • Essbase Formula Optimization
    • Essbase Member Consolidation
    • Simple Essbase Member Formulas
    • Complex Essbase Member Formulas
    • Formulas on Sparse Dimensions in Large Outlines
    • Constant Values Assigned to Members in a Sparse Dimension
    • Nonconstant Values Assigned to Members in a Sparse Dimension
    • Cross-Dimensional Operators in Member Formulas
    • Manage Formula Execution Levels
  • Bottom-Up and Top-Down Calculation
  • Hybrid Mode for Fast Analytic Processing
    • Benefits of Hybrid Mode
    • Comparison of Hybrid Mode, Block Storage, and Aggregate Storage
    • Get Started with Hybrid Mode
    • Optimize the Cube for Hybrid Mode
    • Limitations and Exceptions to Hybrid Mode
    • Solve Order in Hybrid Mode
  • Essbase Caches and Calc Performance
    • Size the Calculator Cache
    • Size the Dynamic Calculator Caches
  • Block Locking and Concurrent User Access
  • Two-Pass Calculation
    • Interaction of Two-Pass and Intelligent Calculation
    • Two-Pass on Default Calculations
    • Calculation Scripts for Two-Pass and Intelligent Calculation
  • Member Set Functions and Performance
  • #MISSING Values
  • Identify Additional Calculation Optimization Issues
• 35 Comparison of Aggregate and Block Storage
  • Inherent Differences with ASO
  • Outline Differences for ASO
  • Calculation Differences for ASO
  • Partitioning Differences for ASO
  • Data Load Differences for ASO
  • Query Differences with ASO
  • Feature Differences in ASO
  • Hybrid Mode
• 36 Design Aggregate Storage Applications
  • Design Flow for Aggregate Storage Applications
  • Aggregate Storage Applications, Cubes, and Outlines
    • Hierarchies in ASO Cubes
    • Design Considerations for Aggregate Storage Outlines
    • 64-bit Dimension Size Limit for Aggregate Storage Outline
    • Compression Dimension for Aggregate Storage Cubes
    • Verify Aggregate Storage Outlines
    • Outline Paging in Aggregate Storage Cubes
    • Compact the Aggregate Storage Outline
  • Develop Formulas on Aggregate Storage Outlines
    • Formula Syntax for Aggregate Storage Databases
    • Write Formulas on Aggregate Storage Outlines
• 37 Load, Calculate, and Retrieve Aggregate Storage Data
  • Build Dimensions in Aggregate Storage Cubes
    • Load Rule Differences for Aggregate Storage Dimension Builds
    • Source Data Differences for Aggregate Storage Dimension Builds
    • Build Alternate Hierarchies in Aggregate Storage Databases
  • Exclusive Operations on Aggregate Storage Cubes
  • Load Data into Aggregate Storage Cubes
    • Load Data Incrementally through a Data Load Buffer
    • Data Load Buffer Resource and Disk Space Usage
    • Data Load Buffer Properties
    • Multiple Data Loads in Parallel
    • List Data Load Buffers for an Aggregate Storage Cube
    • Create a Data Slice
    • Merge Incremental Data Slices
    • Replace Data Using Incremental Data Slice Contents
    • View Incremental Data Slices Statistics
    • Renegade Members in Aggregate Storage Data Loads
    • Source Data Differences for Aggregate Storage Data Loads
  • Clear Data from Aggregate Storage Cubes
  • Block Storage Calculation Features That Do Not Apply to Aggregate Storage
  • Aggregation of Data in an ASO Cube
    • Aggregation-Related Essbase Terms
    • Perform ASO Aggregations
    • Optimization for Aggregate View Selection
    • Generate Aggregate Views Automatically
    • Select Views Based on Usage
    • View Selection Based on Aggregate Level Usage
    • Aggregation Scripts for Essbase ASO Cubes
    • Clear Aggregated Data from the Cube
    • Replace Aggregated Data in the Cube
  • Calculation Order and Solve Order in ASO Cubes
  • Time Balance and Flow Metrics in ASO Accounts Dimensions
  • Retrieve Aggregate Storage Data
• 38 Custom Calculations and Allocations on Aggregate Storage Cubes
  • Custom Calculations on Aggregate Storage Cubes
    • List of Custom Calculations Criteria
    • Write and Run ASO Custom Calculations
    • Sample Use Case for Custom Calculations
    • Optimize Custom Calculations with NONEMPTYTUPLE
  • Custom Allocations on Aggregate Storage Cubes
    • List of Allocation Criteria
    • Regions in ASO Allocations
    • Specify Allocation Criteria
    • Set the POV
    • Set the Range
    • Set the Amount
    • Set the Basis
    • Set the Target
    • Set the Allocation Method
    • Set the Rounding Method
    • Set the Offset
    • Balance Allocations
    • Basis and Target Time Span
      • Example 1: Basis and Target Time Span—Empty or Single Member
      • Example 2: Basis Time Span—Empty or Single Member; Target Time Span—Multiple Members
      • Example 3: Basis Time Span—Multiple Members; Target Time Span—Empty or Single Member
      • Example 4: Basis and Target Time Span—Multiple Members; Basis Time Span Option—Split
      • Example 5: Basis and Target Time Span—Multiple Members; Basis Time Span Option—Combine
      • Examples of Aggregate Storage Allocations
    • Sample Use Case for Aggregate Storage Allocations
    • Data Consistency and Formulas
  • Data Load Buffers for Custom Calculations and Allocations
  • Offset Handling for Custom Calculations and Allocations
  • Credit and Debit Processing for Custom Calculations and Allocations
• 39 Manage Aggregate Storage Applications and Cubes
  • Aggregate Storage Cache
  • Aggregate View Build Optimization
  • Aggregate Storage Cube Restructuring
    • Levels of Aggregate Storage Cube Restructuring
    • Outline-Change Examples
      • Example: No Change in the Number of Stored Levels in a Hierarchy
      • Example: Change in the Number of Stored Levels in a Hierarchy
      • Example: Changes in Alternate Hierarchies
      • Example: Addition of Child Members
      • Example: Addition of Child Branches
  • Export Aggregate Storage Cubes
  • Stored Levels in an Aggregate Storage Outline
• A Limits
  • Name and Related Artifact Limits
  • Data Load and Dimension Build Limits
  • Aggregate Storage Database Limits
  • Block Storage Database Limits
  • Drill-through to Oracle Applications Limits
  • Other Size or Quantity Limits
• B Naming Conventions for Essbase
  • Naming Conventions for Applications and Databases
  • Naming Conventions for Dimensions, Members, and Aliases
  • Naming Conventions for Dynamic Time Series Members
  • Naming Conventions for Attribute Calculations Dimension Member Names
  • Naming Conventions in Calculation Scripts, Report Scripts, Formulas, Filters, and Substitution and Environment Variable Values
  • List of Essbase System-Defined Dimension and Member Names
  • MaxL Reserved Words List