Table 33 lists the types of partitions that are supported in Essbase:
Table 33. Partition Types
Partition Type | Description | Applies To |
---|---|---|
A copy of a portion of the data source that is stored in the data target. | Block storage databases Aggregate storage databases | |
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. | Block storage databases Aggregate storage databases | |
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 |