FIX...ENDFIX

The FIX...ENDFIX command block restricts database calculations to a subset of the database. All commands nested between the FIX and ENDFIX statements are restricted to the specified database subset.

Syntax

FIX (fixMbrs)
COMMANDS ;
ENDFIX

fixMbrs A member name or list of members from any number of database dimensions. fixMbrs can also contain:
AND/OR operators. Use the AND operator when all conditions must be met. Use the OR operator when one condition of several must be met.
Member set functions, which are used to build member lists based on other members.

COMMANDS The commands you want to be executed for the duration of the FIX.

Description

The FIX command is a block command that allows you to define a fixed range of dimensions or members to which the associated commands are restricted. The FIX command is often used to calculate a subset of the database. This is useful because it allows you to calculate separate portions of the database using different formulas, if necessary. It also allows you to calculate the sub-section much faster than you would otherwise.

The ENDFIX command ends a FIX command block. As shown in the following example, you call ENDFIX after all of the commands in the FIX command block have been called and before the next element of the calc script.

Notes

FIX commands can be nested within other FIX command blocks.
FIX commands can only be used in calc scripts, not in outline formulas.
AND/OR operators have the same precedence; Hyperion Essbase evaluates them from left to right. Use parentheses to group the expressions. For example: A OR B AND C is the same as ((A OR B) AND C). However, if you use (A OR (B AND C)), Hyperion Essbase evaluates the sub-expression in parentheses (B AND C) before the whole expression, producing a different result.
Inside FIX statements, the AND operator represents the intersection of two sets; the OR operator represents the union of two sets. In formulas, these operators are Boolean operators.
You do not need to follow ENDFIX with a semicolon.
You can specify attributes in FIX statements using the @ATTRIBUTE and @WITHATTR functions; for example FIX(@ATTRIBUTE(Can)). You must use these functions; FIX(Can) is not supported.
You cannot use a FIX statement in a nested fix within a member association.

Example

FIX (Budget)
   CALC DIM (Year, Measures, Product, Market);
ENDFIX

FIX (Budget, Jan, Feb, Mar, @DESCENDANTS(Profit))
   CALC DIM (Product, Market);
ENDFIX

This example fixes on the children of East and the members on the Market dimension that have a UDA (User-Defined Attribute) of New Mkt.

FIX (@CHILDREN(East) OR @UDA(Market, "New Mkt"))

This example fixes on the children of East that have a UDA (User-Defined Attribute)of New Mkt and the members on the Market dimension that have a UDA of Big Mkt.

FIX((@CHILDREN(East) AND @UDA(Market, "New Mkt")) OR @UDA(Market,"Big Mkt"))

See Also

LOOP...ENDLOOP

fixMbrs	A member name or list of members from any number of database dimensions. fixMbrs can also contain: AND/OR operators. Use the AND operator when all conditions must be met. Use the OR operator when one condition of several must be met. Member set functions, which are used to build member lists based on other members.
COMMANDS	The commands you want to be executed for the duration of the FIX.