To specify a default alias table for a database connection:
Select File, then Preferences.
The User Preferences dialog box is displayed. Note that you are setting the default alias table for active preferences. If it is a shared preference, you are setting the default alias table for all users sharing this preference file.
Optional: To edit database preferences for a database connection, select the database connection from the list and click Edit.
Optional: To add a database connection to the list, click Add.
The Database Preferences dialog box is displayed. It has three tabs: General, Point of View, and Personal Variables. Note that the Point of View and Personal Variable tabs are disabled until a database connection is identified.
Optional: To identify a database connection file, perform one:
Click the Browse button and navigate to an database connection file in the repository. Select the file and click the Open dialog box OK.
Enter the repository location and file name for a database connection file in the text area.
If you cannot access database connections, See Managing Database Connections, or consult your Web Analysis Studio administrator.
Click Connect, to retrieve the latest values.
You may be prompted by the Database Login dialog box, to log on to the data source. Enter logon credentials, and click OK.
When you connect to the data source, the Database File Location text area is disabled, and Connect is converted to Disconnect. If you are using a data source that supports POV, Personal Variables and Alias Tables, these controls are enabled.
Select one of these options from the Default Logon group:
Default Logon Options
Description
Use User's ID and Password
Connects to the database connection using the Web Analysis Studio user ID and password.
Prompt for User ID and Password
Connects to the database connection by prompting the user for a Web Analysis Studio user ID and password.
Enter User ID and Password
Connects to the database connection using a user ID and password for the database connection, if it varies from the Web Analysis Studio Login parameters. You must enter values in the corresponding text areas.
Whenever the specified database connection is used, the selected label mode is also used. Subsequent label mode selections made in the Data Layout or the Dimension Browser overwrite these default settings.