Create a Location Alias

Create a location alias if you need addressability to another Essbase cube for your block storage (BSO) calculations or formulas. Location alises help you call @XREF or @XWRITE functions 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 using 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 Home 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 Select an Essbase connection field, choose a saved connection to the Essbase instance that hosts the remote cube, or choose Within same instance if the cube is in the same Essbase instance.

    Note:

    The username appears when you create a location alias using an Essbase connection other than Within same instance.

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.