Table of Contents
- Title and Copyright Information
- Accessibility and Support
- 1 Case Study: Designing a Single-Server, Multidimensional Database
-
2
Overview of Multidimensional Databases
- OLAP and Multidimensional Databases
- Dimensions and Members
- Data Storage
- The Essbase Solution for Creating Optimized Databases
- 3 About Applications and Databases
- 4 Work with Essbase Outlines
- 5 Dimension and Member Properties
-
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
-
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
- 8 Design and Build Currency Conversion Applications
- 9 Design Partitioned Applications
- 10 Create and Maintain Partitions
- 11 Overview of Data Load and Dimension Build
-
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
- Perform Operations on Fields
- Perform Operations on Data
- Validate Rules
-
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
- 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
-
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
- Build Attribute Dimensions and Associate Attributes
- Build Shared Members
- Build Duplicate Member Outlines
- 15 Modeling Data in Private Scenarios
- 16 Calculate Essbase Block Storage Databases
-
17
Develop Formulas for Block Storage Cubes
- Implement Essbase Formulas and Formula Calculations
- Essbase Formula Syntax
- Use Functions in Formulas
- Use Substitution Variables in Formulas
- Use Formulas on Partitions
- Display Formulas
- 18 Formula Examples for Block Storage Databases
- 19 Block Storage Database Calculation Order
-
20
Intelligent Calculation for Block Storage Cubes
- Ways to Use Intelligent Calculation
- Intelligent Calculation and Data Block Status
- The SET CLEARUPDATESTATUS Command
- Intelligent Calculation of Data Blocks
- Examples with SET CLEARUPDATESTATUS
- Effects of Intelligent Calculation
- Limitations of Intelligent Calculation
- Considerations for Intelligent Calculation on Oracle Exalytics In-Memory Machine
- 21 Dynamic Calculation of Data Values
- 22 Calculate Time Series Data
-
23
Develop Calculation Scripts for Block Storage Cubes
- Calculate a Cube with Calculation Scripts
- Learn Basic Calculation Script Syntax
- Use Calculation Commands
- Formulas in Calculation Scripts
- Substitution Variables in Calculation Scripts
- Runtime Substitution Variables in Calculation Scripts Run in Essbase
- Runtime Substitution Variables in Calculation Scripts Run in Smart View
- Clear and Copy Data
- Calculate a Subset of Data in the Cube
- Enable Calculations on Potential Blocks
- Use Calculation Scripts on Partitions
- Save, Execute, and Copy Calculation Scripts
- Check Calculation Results
- 24 Examples of Calculation Scripts for Block Storage Databases
-
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
-
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
- 30 Control Access to Database Cells Using Security Filters
- 31 MaxL Data Definition Language
- 32 Optimize Database Restructuring
- 33 Optimize Data Loads
-
34
Block Storage Calculation Optimization
- Design for Calculation Performance
- Monitor and Trace Calculations
- Calculate Selected Tuples
- Simulate Calculations to Estimate Calculation Time
- 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
- Essbase Caches and Calc Performance
- Block Locking and Concurrent User Access
- Two-Pass Calculation
- Member Set Functions and Performance
- #MISSING Values
- Identify Additional Calculation Optimization Issues
- 35 Comparison of Aggregate and Block Storage
- 36 Design Aggregate Storage Applications
-
37
Load, Calculate, and Retrieve Aggregate Storage Data
- Build Dimensions in Aggregate Storage Cubes
- 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
-
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
- A 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