When creating or editing partitions, you use the Areas tab to define the areas of the source database that you want to share with the target database.
From the “Editing options” group, you select an option, double-click in the Source or Target column, and then specify the members to be included in the partitioned area:
Options of the “Editing options” group:
Use member selection tool—Displays the Area Mapping Member Selection dialog box, which you use to select member names
Use text editor—Displays the Area Definition dialog box, which you use to enter member names manually
Use inline editing—Enables you to enter member names manually in the column for the partitioned area
Note: | When using the text editor or inline editing options, for duplicate member names, you must enter qualified names (to distinguish between duplicate members). You can view qualified names in the Member Properties dialog box in Outline Viewer. When you use the member selection tool, qualified names are inserted automatically. |
The Source and Target columns list the member names and substitution variable names of the source and target databases.
You select the Show cell count option to display, in the #Cell area, the number of data cells within the partitioned area of the source and target databases.
Note: | Cell count is calculated by multiplying the number of partitioned members within one dimension by the number of partitioned members within another dimension by the number of partitioned members within another dimension and so on. For dimensions that a partition definition does not reference, the total number of cells within the dimension is used. There should be a one-to-one correspondence between source and target cells. A difference between source cell count and target cell count is called a cell count mismatch. Replicated and transparent partitions with cell count mismatches are not valid. A cell count mismatch does not affect the validity of linked partitions. |
You click the Advanced button if you want to set mapping information conditionally.
create partition (MaxL) in the Oracle Essbase Technical Reference
display partition (MaxL) in the Oracle Essbase Technical Reference