Create Location Alias

Create on the database a location alias identifying a host name, database, user name, and password. Location aliases provide a shorthand way of referencing login information for other cubes.

Minimum permission required: Database Manager.

Syntax

Description of the illustration creloc.gif

• LOC-ALIAS-SINGLE

• LOCATION-ALIAS-NAME

• DBS-NAME

• HOST-NAME

• USER-NAME

• PASSWORD

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://myEssbase-myDomain.analytics.us2.example.com/essbase/agent" as smith identified by 'password';

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

• remote host = https://myEssbase-myDomain.analytics.us2.example.com/essbase/agent

• application = East

• database = Sales

• user name = Fiona

• password = sunflower