FIX Operator and Restricted Key Figures

The following is an example without constant selection and serves to show that the FIX operator can also be used in cases like this.

Working without constant selection offers no benefits however, as you obtain the same results as you would have without the FIX operator.

The following example has the following key figures:

The basic key figure is Sales again.
The second key figure is the restricted key figure Sales (Product A), restricted to product "A".
The third key figure is the restricted key figure Sales (Product A, Product B), restricted to the products "A" and "B".
The fourth key figure is calculated using a formula: Sales (Product A) / Sales (Product A, Product B) with Exception Aggregation SUM by Product.

Table 1: FIX Operator and Restricted Key Figures, Table 1
Product	Sales	Sales (Product A)	Sales (Product A, Product B)	Sales (Product A) / Sales (Product A, Product B) by Product
A	EUR 450	EUR 450	EUR 450	1
B	EUR 1200		EUR 1200
Total	EUR 1650	EUR 450	EUR 1650	1

The formula that the analytic manager executes is as follows:

SUM( Sales (Product A)/ Sales (Product A, Product B) ) by Product

Incorporating the FIX operator, this formula is:

SUM( Sales (Product A)/FIX( Sales (Product A, Product B) ) ) by Product

Table 2: FIX Operator and Restricted Key Figures, Table 2
Product	Sales	Sales (Product A)	Sales (Product A, Product B)	SUM( Sales (Product A)/FIX( Sales (Product A, Product B) ) ) by Product
A	EUR 450	EUR 450	EUR 450	1
B	EUR 1200		EUR 1200
Total	EUR 1650	EUR 450	EUR 1650	0,27

The FIX operator causes Sales (Product A) / Sales (Product A, Product B) to be aggregated with the standard aggregation, as there is no exception aggregation defined in the inner formula. As the FIX operator removes the GROUP-BY clause for Product, the entire formula exception aggregation by product is omitted. The calculation therefore has the same result as it would if no exception aggregation had been defined in the formula.