Setting Alias Tables

  Specify default alias tables for database connections:

1. Select File, then Preferences.

2. Click Web Analysis.

3. Click Active Preferences, and select either Use My Preferences, or Use Shared Preferences. If you select Use Shared Preferences, click Browse and select a shared preferences file from the repository.

4. Click to make the Databases tab the current tab.

   The Databases tab lists all available database connections for the active user.

5. Optional: To edit database preferences for a database connection, select the database connection from the list then click Edit.

6. Optional: To add a database connection to the list, click Add.

   The Database Preferences dialog has three tabs: Details, Point of Views, and Personal Variables. Point of Views and Personal Variable tabs are disabled until a database connection is identified.

7. Optional: To identify database connection files, perform one:

   • Click Browse and navigate to a database connection file in the repository. Select the file, click Open then OK.

   • Enter the repository location and filename for existing database connection files in the text area.

     If you do not have access to database connection files, consult your Web Analysis administrator.

8. Click Connect to retrieve the latest values from the database connection.

   To log on to the data source, enter log on credentials, click OK.

   When you have connected to the data source, the Database File Location text area is disabled, and the Connect button is converted to a Disconnect button. Data sources supporting Point of View, Personal Variables and Alias Tables have these controls.

9. Select an alias table from the Alias Table drop down list.

10. Click OK.

    Whenever the specified database connection is used, the selected label mode is also used. Subsequent label mode selections made in the Cube Navigator or the Dimension Browser overwrite these default settings.