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 Hyperion Essbase databases. Minimum permission required: Database designer.

Syntax

Notes

Examples

create location alias EasternDB from Sample.Basic to East.Sales at Easthost as Fiona identified by sunflower;

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

Descriptions

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

Key Phrase Explanation
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 the remote host name on which the remote database resides.
...as <user-name> identified by <password> Specify a user name and password with which to log in to the remote database.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com