After you create a location alias, you can use the alias to refer to the other cube. If the location of the cube changes, edit the location definition accordingly.

You can use location aliases only with the @XREF and @XWRITE functions. With @XREF, you can retrieve a data value from another cube to include in a calculation on the current cube. In this case, the location alias points to the cube from which the value is to be retrieved. With @XWRITE, you can write values to another Essbase cube, or to the same cube.

The following considerations apply when using location aliases in secure (TLS/SSL) mode. For information on implementing TLS, see Secure Your Communication and Network with TLS and Certificates. If your network is secure, the ENABLESECUREMODE configuration setting should be set to TRUE. If the location alias is set up to a secure port, append :secure to the server name specification. For example, using MaxL: create location alias EasternDB from Sample.Basic to East.Sales at Easthost:6423:secure as User1 identified by password1;.

You can create a location alias for a particular cube. To create a location alias using the Essbase web interface refer to Create a Location Alias. Or, you can use the create location alias MaxL statement.