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.
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:
- server = Easthost
- application = East
- database = Sales
- user name = Fiona
- password = sunflower
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 |