You use the Type tab of the create and edit partition windows to specify partition type and partition settings.
If you are creating a partition, from the “Partition type” group, you select a partition type:
Replicated—Copy data from the partitioned area of one database to another database (For aggregate storage databases, you cannot create replicated partitions.)
Linked—Enable spreadsheet users to link from a member combination in one database to a member combination in another database
Transparent—View data that is stored in two databases as if it were stored in one database
Whether you are creating or editing a partition, you can select one or more of the following options:
Outline changes move in the same direction as data changes—Select this option to propagate source-outline changes to the target outline during outline synchronization. Clear the option to propagate target-outline changes to the source outline during synchronization. (For information about synchronizing outlines, see the Oracle Essbase Database Administrator's Guide)
Note: | If the source database uses aggregate storage, the outline changes option does not apply. |
The target partition can be updated—For replicated partitions, you can select this option to allow users to update data in the target database. If the option is cleared, users cannot update data in the target database. Before selecting or clearing the option, consider the following
When a replicated partition is updated, Essbase overwrites changes that users have made to the target database.
Users cannot calculate, load data into, or use Spreadsheet Add-in to change information within replicated areas that they cannot update. Therefore, in this case, data within a replicated area can be changed only at the source database.
If you do not select “The target partition can be updated,” security filters that allow user updates are overridden.
Default source login—For linked partitions, you can enter the default login information for the source database. For length limits, See the Oracle Essbase Database Administrator's Guide. If the option is selected, client applications, such as Spreadsheet Add-in, use the entered information to connect to the source database.
The Synchronization Status box displays information about the synchronization of source and target outlines and data. See also Synchronizing Outlines.
“Partition Types” in the Oracle Essbase Database Administrator's Guide
“Synchronizing Outlines” in the Oracle Essbase Database Administrator's Guide
create partition (MaxL) in the Oracle Essbase Technical Reference
display partition (MaxL) in the Oracle Essbase Technical Reference