Removing Group-By Characteristics in Formula Exception Aggregation

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 that is performed before a second level calculation;
• determining an operator in the query configured to explicitly remove group by information for a reference characteristic in the first level calculation, wherein the group by information is specified for the reference characteristic in the second level calculation;
• performing the first level calculation by removing the group by information for the reference characteristic for the first level calculation to determine a first level calculation result;
• 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.

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 that is performed before a second level calculation;
• determining an operator in the query configured to explicitly remove group by information for a reference characteristic in the first level calculation, wherein the group by information is specified for the reference characteristic in the second level calculation;
• performing the first level calculation by removing the group by information for the reference characteristic for the first level calculation to determine a first level calculation result;
• 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.