@XREF is an Essbase calculation function for referencing data in another cube. @XWRITE is a calculation function for writing back data to another cube. The cube containing the @XREF or @XWRITE formula is called the local cube. The second cube is called the remote cube.

To implement @XREF, you define a formula in the local cube that pulls values from a remote cube. The member containing the @XREF formula can either be stored or dynamically calculated.

To implement @XWRITE, you define a formula in the local cube that pushes (writes) values into a remote cube. The remote cube data intersection must be stored, since @XWRITE writes values into the remote cube.

If the local and remote cubes are on different Essbase instances, a location alias containing connection information must be defined.

Function syntax 1 calls for a location alias:

@XREF (locationAlias [, mbrList])
@XWRITE (expression, locationAlias [, mbrList])

Function syntax 2 calls for using an application name and database name combination:

@XREF(appName, dbName [, mbrList])
@XWRITE (expression, appName, dbName [, mbrList])

When using application name and database name combination, users of the local cube must also be provisioned on the remote cube.

Additional References:

• @XREF
• @XWRITE
• Create a Location Alias