Help Topics

General tab


In the General tab, you provide the calculation's name and its position in the dimension when the calculated member appears on the grid. The General tab contains the following fields and options:

Calculation Name
The name of the calculated member.
Dimension
The dimension that the calculated member will appear in. Only the dimensions currently displayed on the row and column axes will appear in the Dimension list.
Position
The position where the calculated member will appear in the grid. The calculated member can appear either at the end of the dimension or before one of the members of the dimension.
Generation level
The generation level determines the indentation of the calculation name if the name is on the row header of the grid. Generation level also determines the calculation's generation level on the chart. The generation level determines where the a member is in the hierarchy. Root members have a generation level of 1. For example, a dimension named Time has the years at level 1, quarters at level 2, and months at level 3.

The generation type affects the generation level:

Absolute
If the generation type is absolute, then the generation level of the calculated member is absolute. For example, an absolute generation level of 1 means that the calculation is a root member, and its name is not indented.
Relative
If the generation type is relative, then the generation level is relative to the member that is selected in the Position list. For example, if the member that is selected in the Position list has a generation level of 2, and the relative generation level for the calculation is +1, then the calculation's absolute generation level is 3.

The name of the generation level appears to the right of the level spinner control.

Note: The generation level applies only to calculations on multidimensional databases.

Replace missing values with Zero
Specifies whether missing values are treated as zeros in the calculation. This option affects only missing values that are part of addition, subtraction, multiplication, or division operations. If this option is not set, then the calculation fails if it is missing values that are part of arithmetic operations. Missing values are always ignored in functions.

 

Related topics: