# Constituent Elements

| Element                                                                                                                                                                                      | Definition                                                             |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------- |
| [SQL](https://docs.pentaho.com/install/9.3-install/multidimensional-data-modeling-in-pentaho/about-multidimensional-expression-language/mondrian-schema-element-reference/sql)               | The SQL WHERE clause expression to be appended to any select statement |
| [AggExclude](https://docs.pentaho.com/install/9.3-install/multidimensional-data-modeling-in-pentaho/about-multidimensional-expression-language/mondrian-schema-element-reference/aggexclude) | Exclude a candidate aggregate table by name or pattern matching        |
| [AggTable](https://docs.pentaho.com/install/9.3-install/multidimensional-data-modeling-in-pentaho/about-multidimensional-expression-language/mondrian-schema-element-reference/aggtable)     | A definition of an aggregate table for a base fact table.              |