General Tab (Properties Dialog Box)
Use this tab to specify whether certain warnings are displayed and to change the folders used by Microsoft® SQL Server™ 2000 Analysis Services.
Options
Enable dimension level counting
Select to cause Analysis Services to count the members in a new dimension level when it is added. If you select this option, whenever a user attempts to add a level below a level with more members, the following warning is displayed.
Although this option provides real-time hierarchical structure validation, counting large numbers of members may take several minutes or longer. Turning off the option speeds up the dimension creation process; however, the hierarchical structure of members is not validated.
Default: Members are counted automatically, and warnings are displayed.
Note In the Dimension Wizard, you can temporarily override this option by using the Count level members automatically check box. The override is effective only for the duration of the wizard.
Show process warning
Select to cause Analysis Services to display the following warning when a new or updated cube is saved without aggregations.
Individual administrators can turn off the option by selecting the Don't show this message again check box in the Design Storage dialog box. Thereafter, the only way to begin displaying the warnings again is to select the Show process warning check box in the Properties dialog box.
Default: Warnings are displayed.
Show database password warning
Select to cause Analysis Services to display a warning when a data source is saved with a password. The following warning is displayed when in the Data Link Properties dialog box, on the Connection tab, an administrator specifies a user name and password, selects the Allow saving of password check box, and then clicks OK.
In the Security Warning dialog box, the administrator can click Cancel to avoid the security exposure.
Individual administrators can turn off the option by selecting the Don't show this message again check box in the Security Warning dialog box. Thereafter, the only way to begin displaying the warnings again is to select the Show database password warning check box in the Properties dialog box.
Default: Warnings are displayed.
To display warnings when data source passwords are saved, select the Show database password warning check box, and then click OK.
Data folder
Select the Data folder used by Analysis Services. If you select a new folder, the temporary file folder (see below) is also changed to that folder. If you select a new folder, Analysis Services does not access existing data.
Important The Data folder stores security files that control end users' access to objects on the Analysis server. For this reason, you must secure the Data folder against unauthorized access.
The maximum allowed length is 102 characters.
Default: C:\Program Files\Microsoft Analysis Services\Data
To change the Data folder used by Analysis Services, click Browse next to the Data folder box, select a new folder, and then click OK.
Temporary file folder
Select the temporary folder used by Analysis Services. If you select a new Data folder, the temporary file folder is also changed to that folder.
The maximum allowed length is 102 characters.
Default: the folder specified in the Data folder box.
To change the temporary file folder used by Analysis Services, click Browse next to the Temporary file folder box, select a new folder, and then click OK. If you change this folder, you must stop and then restart the Analysis server service (MSSQLServerOLAPService).