Create Location Alias

The MaxL create location alias statement helps you create on the Essbase database a location alias referencing another cube.

Minimum permission required: Database Manager.

Syntax

Use create location alias to create a location alias in the following ways:

Keywords

create location alias: Create a location alias, identifying a remote host name, database, user name, and password. The location alias can be used by the @XREF function as an abbreviated login to a remote database.
create or replace location alias: Create a location alias, replacing any existing location alias of the same name on the same database.
...from <dbs-name>: Specify the name of the current database (the database on which the location alias is being created).
...to <dbs-name>: Specify the name of the remote database to log in to.
...at <host-name>: Specify where the remote database resides (using discovery URL).
...as <user-name> identified by <password>: Specify a user name and password with which to log in to the remote database.

Notes

This statement requires the database to be started.
Location aliases created using MaxL must be valid.
Location aliases are used by the @XREF calculation function for cross-database calculations.

Example

create location alias EasternDB from Sample.Basic to East.Sales at "https://192.0.2.1:443/essbase/agent" as adminuser identified by 'password';

Creates a location alias called EasternDB on Sample.Basic that represents the following login information: