"Bad" Aggregate Tables in Foodmart Sample Database

Explanation

These "bad" aggregate tables are deliberately included in the foodmart sample database for demonstration and testing purposes.

If your schema doesn't explicitly exclude these tables, you will get error when Mondrian generates SQL that uses these tables based on its aggregate table selection criteria.

You can use the "<AggExclude>" tag to avoid using these tables. Please refer to the sample foodmart schema on how to achieve this.