Removing group-by characteristics in formula exception aggregation

1. A method comprising:

receiving, by a computing device, a query for analyzing data in a database, wherein the query includes a first level calculation for a reference characteristic that is performed before a second level calculation for the reference characteristic, and wherein the first level calculation includes a constant selection operator of the reference characteristic that is configured to remove a group by of the reference characteristic at the first level calculation;

determining, by the computing device, when a FIX operator is present in the query, the FIX operator configured to explicitly remove group by information for the reference characteristic in the first level calculation;

performing, by the computing device, the first level calculation using the constant selection operator by removing the group by information for the reference characteristic for the first level calculation to determine a first level calculation result, wherein without the use of the FIX operator, the constant selection operator of the reference characteristic would not be used due to a rule specifying the group by information of the reference characteristic should not be removed by the first level calculation when the reference characteristic is present in the first level calculation and the second level calculation; and

performing, by the computing device, the second level calculation using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result, wherein the second level calculation comprises an exception aggregation that uses the first level calculation result in performing the second level calculation, and wherein the exception aggregation performs the second level calculation by aggregating by the reference characteristic to determine the second level calculation result.

2. The method of claim 1 , wherein the FIX operator removes the group by information for only the constant selection operator of the reference characteristic associated with the FIX operator.

3. The method of claim 1 , wherein the FIX operator removes the group by information only for the first level calculation and not the second level calculation.

4. The method of claim 1 , wherein with the use of the FIX operator, the removal of the group by of the reference characteristic overrides the rule.

5. The method of claim 1 , wherein the rule is invoked when the second level calculation includes the group by information for a same reference characteristic as the reference characteristic specified by the constant selection in the first level calculation.

6. The method of claim 1 , wherein:

the first level calculation comprises a first operand, a second operand, and the constant selection operator, and

the FIX operator is associated with one of the first operand and the second operand and removes the group by information for the one of the first operand and the second operand.

7. The method of claim 1 , wherein the FIX operator is configured to not remove the group by information that is specified for the reference characteristic in the second level calculation.

8. The method of claim 1 , when the FIX operator is not present in the query, performing:

calculating, by the computing device, the first level calculation using the group by information for the reference characteristic for the first level calculation to determine the first level calculation result; and

calculating, by the computing device, the second level calculation using the first level calculation result using the group by information for the reference characteristic to determine the second level calculation result.

9. A non-transitory computer-readable storage medium containing instructions, that when executed, control a computer system to be configured for:

receiving a query for analyzing data in a database, wherein the query includes a first level calculation for a reference characteristic that is performed before a second level calculation for the reference characteristic, and wherein the first level calculation includes a constant selection operator of the reference characteristic that is configured to remove a group by of the reference characteristic at the first level calculation;

determining when a FIX operator is present in the query, the FIX operator configured to explicitly remove group by information for the reference characteristic in the first level calculation;

performing the first level calculation using the constant selection operator by removing the group by information for the reference characteristic for the first level calculation to determine a first level calculation result, wherein without the use of the FIX operator, the constant selection operator of the reference characteristic would not be used due to a rule specifying the group by information of the reference characteristic should not be removed by the first level calculation when the reference characteristic is present in the first level calculation and the second level calculation; and

performing the second level calculation using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result, wherein the second level calculation comprises an exception aggregation that uses the first level calculation result in performing the second level calculation, and wherein the exception aggregation performs the second level calculation by aggregating by the reference characteristic to determine the second level calculation result.

10. The non-transitory computer-readable storage medium of claim 9 , wherein the FIX operator removes the group by information for only the constant selection operator of the reference characteristic associated with the FIX operator.

11. The non-transitory computer-readable storage medium of claim 9 , wherein the FIX operator removes the group by information only for the first level calculation and not the second level calculation.

12. The non-transitory computer-readable storage medium of claim 9 , wherein with the use of the operator, the removal of the group by of the reference characteristic overrides the rule.

13. The non-transitory computer-readable storage medium of claim 9 , wherein the rule is invoked when the second level calculation includes the group by information for a same reference characteristic as the reference characteristic specified by the constant selection in the first level calculation.

14. The non-transitory computer-readable storage medium of claim 9 , wherein:

the first level calculation comprises a first operand, a second operand, and the constant selection operator, and

the FIX operator is associated with one of the first operand and the second operand and removes the group by information for the one of the first operand and the second operand.

15. An apparatus comprising:

one or more computer processors; and

a non-transitory computer-readable storage medium comprising instructions, that when executed, control the one or more computer processors to be configured for:

receiving a query for analyzing data in a database, wherein the query includes a first level calculation for a reference characteristic that is performed before a second level calculation for the reference characteristic, and wherein the first level calculation includes a constant selection operator of the reference characteristic that is configured to remove a group by of the reference characteristic at the first level calculation;

determining when a FIX operator is present in the query, the FIX operator configured to explicitly remove group by information for the reference characteristic in the first level calculation;

performing the first level calculation using the constant selection operator by removing the group by information for the reference characteristic for the first level calculation to determine a first level calculation result, wherein without the use of the FIX operator, the constant selection operator of the reference characteristic would not be used due to a rule specifying the group by information of the reference characteristic should not be removed by the first level calculation when the reference characteristic is present in the first level calculation and the second level calculation; and

performing the second level calculation using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result, wherein the second level calculation comprises an exception aggregation that uses the first level calculation result in performing the second level calculation, and wherein the exception aggregation performs the second level calculation by aggregating by the reference characteristic to determine the second level calculation result.