To create a partition, Essbase must be able to map all shared data source members to data target members. Oracle recommends that data source member names and data target member names are the same to reduce maintenance requirements for the partition, especially when the partition is based on member attributes.
If the data source and data target contain the same number of members and use the same member names, Essbase automatically maps the members. You need only validate, save, and test the partitions. If Essbase cannot map automatically, you must map manually.
Map data source members to data target members in any of the following ways:
You can use substitution variables for member names in mapping specifications. See Substitution Variables in Partition Definitions. |
To map members, see “Defining Global Mappings in Partitions” in the Oracle Essbase Administration Services Online Help.