Esb new features.pdf

HYPERION® ESSBASE® – SYSTEM 9
RELEASE 9.3.1

NEW FEATURES

This document describes the new features in Oracle's Hyperion® Essbase® – System 9 Release
9.3.1.
For information about the new features in Oracle's Essbase® Administration Services, see the
Essbase Administration Services New Features booklet.
CONTENTS IN BRIEF

Incrementally Loading Data into Aggregate Storage Databases . . . . . . . . . . . . . . . . . . . . . . 2
Enabling Faster Data Loads from Teradata Data Sources . . . . . . . . . . . . . . . . . . . . . . . . . . 2
Exporting the essbase.sec Security File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
Canceling Operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Improving Retrieval Performance on Large Dimensions . . . . . . . . . . . . . . . . . . . . . . . . . . 3
MaxL and MDX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Where to Get More Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

P/N: DE90293100

Incrementally Loading Data into Aggregate Storage Databases
The aggregate storage database model has been enhanced with the following features: l An aggregate storage database can contain multiple slices of data.

l

Incremental data loads complete in a length of time that is proportional to the size of the incremental data.

l

You can merge all incremental data slices into the main database slice or merge all incremental data slices into a single data slice while leaving the main database slice unchanged. l

Multiple data load buffers can exist on a single aggregate storage database. To save time, you can load data into multiple data load buffers at the same time.

l

You can atomically replace the contents of a database or the contents of all incremental data slices. l

You can