Aggregate dimensions are used to define attributes that splice the data they are associated with. The dimension is therefore based on a table or view and will have one or more attributes, which are the ways we will allow the data to be spliced. Defining the data in this way allows exceptionally fast data analysis. This is because the data is expanded into a data warehouse database automatically by Operations.

In some cases, you may want to create a view to simplify the process, in which case, use the view as the Table property.