Create a Transparent Partition

Create a transparent partition if you need to provide access to data from a source Essbase cube as if it were in 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 >Transparent.
  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 the 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. If you have not enabled member selection, type directly in the source work area. For example, add a source area of some valid upper-level member specifications, 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 a transparent partition area definition, showing a source area of "Actual", "Budget" and a target area of "Actual", "Budget", "Boston"

  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 mappings for a transparent partition, showing "void" for the source and "Boston" for the target

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