What are Aggregation rules?

Aggregation rules tell the application how to group the data together when it is being summed. For example you can group data by day to give a daily view. You can group the data by day and store to give a store sum on each day. You can group the data by day and by transaction to give a sum of each transaction in each store on each day.

Group by examples:

• Day = Lets you see the sum of sales by day.
• Day * Country = Would let you see the sum of sales by country by day.
• Day * Country * Store = Would let you see the sum of sales by country by store by day.
• Day * Country * Store * Transaction ID = Sum of sales by transaction id by store by country by day.
• Day * Country * Store * Transaction ID * Department = As above but splits each transaction into departments and sums sales at this level.