Advanced Settings Definition

In the application template workbook, include a worksheet for advanced settings, using the advanced settings worksheet provided in the template for the Sample application as your guideline.

Advanced settings are:

• Evaluation order

• Performance settings

• Dimension properties such as hierarchy type, two-pass calculations, and data storage options

• Density (for aggregate storage applications only)

• Dimension assignments to cubes

Follow this workflow for setting up an advanced settings worksheet in your application template workbook:

1. Define the Worksheet Name

2. Define the Worksheet Name

3. Define Evaluation Order

4. Define Performance Settings

5. Define Dimension Settings

6. Define Density Settings

7. Assign Dimensions to Cubes

Define the Worksheet Name

Name the advanced settings definition worksheet, Advanced Settings. For example:

Define the Worksheet Type

In cell A1 in the data worksheet, type Advanced Settings to signify that this sheet contains the advanced, or miscellaneous settings for the application. In Figure E-9, cell A1 contains the worksheet type, Advanced Settings, to indicate that the worksheet will contain advanced settings for the application.

Figure E-9 Worksheet Type Shown in Advanced Settings Worksheet of Application Template

Define Evaluation Order

In the Advanced Settings worksheet, define the evaluation order of dimensions in the "Evaluation Order" section. Dimensions are listed in the first column under the heading "Dimensions". Cubes are listed in subsequent columns. The dimensions in each cube can have a different evaluation order.

Define Performance Settings

For Planning applications only.

In the Advanced Settings worksheet, define dimension storage property of each dimension for each cube in the "Performance Settings" section. Valid values are Dense or Sparse. Each cube requires at least one dense dimension. Dimensions are listed in the first column under the heading "Dimensions". Cubes are listed in subsequent columns. The sparse or dense value of each dimension can differ between cubes.

Define Dimension Settings

In the Advanced Settings worksheet, define dimensions properties in the "Dimension Settings" section. Dimensions are listed in the first column under the heading "Dimensions". Dimension properties are listed in subsequent columns. See Table E-5 for the list of dimension properties

Table E-5 Dimension Properties Used in Dimension Settings Section of the Advanced Settings Worksheet

Dimension Property	Description or Valid Values
Description	Optional descriptive text
Alias Table	Optional alias table
Hierarchy Type	Dynamic Store
Two Pass Calculation	Yes | No
Apply Security	Yes | No
Data Storage	Store Dynamic Calc and Store Dynamic Calc Never Share Label Only Shared
Display Option	Set application default display options for the Member Selection dialog box. Select Member Name or Alias to display members or aliases. Member Name:Alias displays members on the left and aliases on the right. Alias:Member Name displays aliases on the left and members on the right. Member Name Alias Member Name:Alias Alias:Member Name

You can also use Figure E-10 for reference in adding information to the Dimension Settings section.

Figure E-10 Dimension Settings Section of the Advanced Settings Worksheet

Define Density Settings

For Planning Modules applications only.

In the Advanced Settings worksheet, define the dimension storage property of each dimension for each cube in the "Density" section. Each cube requires at least one dense dimension. Dimensions are listed in the first column under the heading "Dimensions". Cubes are listed in subsequent columns. The sparse or dense value of each dimension can differ between cubes.

Assign Dimensions to Cubes

In the Advanced Settings worksheet, assign dimensions to cubes in the "Dimension Valid for" section. Dimensions are listed in the first column under the heading "Dimensions". Cubes are listed in subsequent columns.

For each dimension and cube intersection:

• Type Yes to include the dimension in the cube.

• Type No or leave the cell blank to exclude the dimension from the cube.