Create a Replicated Partition

Create a replicated partition if you need to provide access to data from a source Essbase cube by duplicating some of it into the current (target) cube. The source cube can be on the same Essbase instance, or a remote instance.

  1. On the Home page, open the target application and then open the target database (cube).
  2. Click Partitions.
  3. Click Create >Replicated.
  4. On the Connection tab, in the Server field, if the source cube is on a different Essbase instance, enter the URL for that Essbase instance.
    If the URL doesn't work, you can use the Essbase host and port. For example, 
    myserver.example.com:1423

    Note:

    Do not enter the remote instance details in the target server name.
  5. Enter your User name and Password, then click Image of the validate user icon in the partition editor. to Validate User.
  6. Click Image of the refresh applications icon in the partition editor. to Refresh Applications, then select source application and database (cube), and enter an optional description.
  7. In the Target Information, enter your User name and Password, then click Image of the validate user icon in the partition editor. to Validate User.
  8. You need to define at least one area. Go to the Areas tab.
  9. (Optional) Select Use member selection using the toggle switch to select members from the outline. If you choose not to use member selection, type directly in the work area.
  10. (Optional) Click Open Source Area Image of the Open Source Area or Open Target Area icon in the partition editor.to open a larger work area.
  11. If you have enabled member selection in step 9, click Edit source area Image of the edit area pencil icon in the partition editor. and provide at least one source area definition. For example, add a source area of some @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.
    Image of the areas tab in a replicated partition, showing @DESCENDANTS(Product) for both source and target.

  12. Click Cell count to identify how many cells are in the defined partition area and to ensure that the counts are matching.
  13. 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. See Mapping Members in Partitions.
    Image of the mappings tab in a replicated partition, showing mappings of "East" to "Eastern_region", "West" to "Western_region", "South" to "Southern_region" , and "Central" to "Central_region".

  14. Click Validate.
  15. If the validation succeeded, click Create.