Partition Types

Table 33 lists the types of partitions that are supported in Essbase:

Table 33. Partition Types

Partition Type

Description

Applies To

Replicated

A copy of a portion of the data source that is stored in the data target.

See Replicated Partitions.

Block storage databases

Aggregate storage databases

Transparent

Allows users to access data from the data source as though it were stored in the data target. The data is, however, stored at the data source, which can be in another application or Essbase database, or on another Essbase Server.

See Transparent Partitions.

Block storage databases

Aggregate storage databases

Linked

Sends users from a cell in one database to a cell in another database. Linked partitions give users a different perspective on the data.

See Linked Partitions.

Block storage databases

Aggregate storage databases

Use the information in Table 34 to help you choose which type of partition to use:

Table 34. Features Supported by Partition Type

Feature

Replicated

Transparent

Linked

Up-to-the-minute data

 

x

x

Reduced network traffic

x

 

x

Reduced disk space

 

x

x

Increased calculation speed

x

  

Smaller databases

 

x

x

Improved query speed

x

 

x

Invisible to end users

x

x

 

Access to databases with different dimensionality

  

x

Easier to recover

x

  

Less synchronization required

  

x

Ability to query data based on its attributes

 

x

x

Ability to use front-end tools that are not distributed OLAP-aware

x

x

 

Easy to perform frequent updates and calculations

 

x

 

Ability to update data at the data target

 

x

x

View data in a different context

  

x

Perform batch updates and simple aggregations

x