Changing the Configuration Settings

What are configuration settings?

The configuration settings control and define the behavior of an OLAP service. All of the configuration parameters have default settings that are appropriate for most installations.

Which settings do I change?

Default values are provided for all required settings. You only need to change the settings that you have identified as inappropriate for your installation.

The following are some common reasons for changing the default settings:

• Change the password for the proxy and DBA users

• Change the character set that the service uses for internal text manipulations

• Improve performance

• Change the identifiers for additional instances of OLAP services

• Identify additional disk drives where the service can create temporary files

Procedure: Changing a configuration setting

Follow these steps to change a configuration setting:

1. Open Instance Manager by taking the steps listed in "Procedure: Opening Instance Manager".

2. Click the plus icon next to Parameters.

   You see the expanded list of categories.

3. Select a category.

   You see the sheet that lists the parameters grouped under that category.

   Tip: To find a specific parameter when you don't know its category, search Help for that parameter by name.

4. Choose Help for further information.

5. Stop and restart the OLAP service so that the changes will take effect. Your changes have no effect on the currently running instance.

Figure: Parameter sheets

The following figure shows the expanded list of parameter sheets. The workspace paging parameters are currently displayed.

Related information

For further information about configuration settings, search Instance Manager Help for parameters by name, or for the following topics:

"Adding Configuration Parameters"

"Changing a Configuration Parameter"

"Removing Configuration Parameters"