Create a Replicated Partition

This topic shows you how to create a replicated partition, which duplicates an area of a source cube into the target cube. The data source can be in another cube, or on another Essbase instance.

If your source cube is on a different Essbase instance, you must first define an Essbase connection as described in Define a Reusable Connection for Partitions or XREF/XWRITE.

1. In the Essbase web interface, on the Applications page, expand the target application. In the row for the target cube, click the Actions menu, and click Inspect.
2. Select the Partitions tab.
3. Click Create >Replicated.
4. On the Connection tab, in Source Info, if the source cube is on a different Essbase instance, select the name of the saved connection that you created. If the source cube is on the same Essbase instance, leave the Connection Name field empty. If you have not created any connections, you will not see a Connection Name field.
5. Provide the source Application and Database name, and an optional Description.
6. If the source cube is on a different Essbase instance, in the Target Info, type a provisioned User name and password.
7. You need to define at least one area. Go to the Areas tab.
8. Click Add Area and provide at least one source and target area definition. For example, add a source area of @DESCENDANTS(valid upper-level member specification), and add the same matching target area. If the same member doesn’t exist in both cubes, create an area mapping as described below.
9. Click Cell count to see how many cells are in the defined partition area and to ensure that the counts are matching.
10. Optionally, you can map member names between the target and source cubes within a specific area, using the Areas tab, or for multiple areas, using the Mappings tab.
11. Click Validate.
12. If the validation succeeded, click Save and Close.