1. Using Oracle Essbase
  2. Link Cubes Using Partitions or @XREF/@XWRITE
  3. Create a Location Alias

Create a Location Alias

Create a location alias enabling addressability to another Essbase cube. You can use a location alias when your calculations/formulas use @XREF or @XWRITE to reference data from another cube, whether that cube is on the same Essbase instance or a different one.

You do not need to provide a user name and password when you create a location alias in the Essbase web interface. However, if the remote cube is not on the same Essbase instance, a saved connection is required (refer to Define a Reusable Connection for Partitions or Location Aliases if you need to create one).
  1. Navigate to the Location Aliases page.
    • In the Redwood Interface, on the Applications page, open the application and then open the database (cube).
    • In the Classic Web Interface, on the Applications page, expand the target application. In the row for the local cube, click the Actions menu, and click Inspect.
  2. Click Location Aliases.
  3. Click Add Location Alias.
  4. In the Location alias name field, enter a name.
  5. In the Essbase connection field, select a saved connection to the Essbase instance hosting the remote cube, if it is not within the same Essbase instance, or select Within same instance.
  6. Select the remote application and database and click Save.
To use the location alias for read operations from a remote cube to the target, use the @XREF function in a member formula or calculation script on the local cube. To use it to write from the local to the remote cube, use @XWRITE on the local cube.