If you have Database Manager permissions, you can create location aliases. A location alias, which maps an alias name to the physical location of its database, specifies an Essbase Server, an application, a database, a user name, and a password.
You can use aliases to refer to databases and can edit location definitions.
You can use location aliases only with the @XREF function. With this function, you can retrieve a data value from a database other than the current database and include the value in calculations on the current database. The location alias points to the database from which the value is retrieved.
Note: | Location aliases do not apply to aggregate storage databases. |
To create location aliases for databases:
From Enterprise View or a custom view, select a database.
Right-click, and select Edit, and then Location aliases.
The Location Aliases window is displayed.
In Alias, enter an alias for the database.
Enter or select alias information, information about the server that contains the database.
Click Test to verify the location alias information.
When the location alias information is valid, the check box in the Verified column is selected.
Click Set.
create location alias (MaxL) in the Oracle Essbase Technical Reference
display database (MaxL) in the Oracle Essbase Technical Reference
createlocation (ESSCMD) in the Oracle Essbase Technical Reference
listlocations (ESSCMD) in the Oracle Essbase Technical Reference