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:
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 |
|
Two Pass Calculation |
Yes | No |
Apply Security |
Yes | No |
Data Storage |
|
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.
|
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.