As usual I first start with a piece of theory from the oracle documentation.
A business view is a visual representation of data fetched by a business query or one or more KPIs. In most views, numeric data fields, called measures, are grouped by non-numeric data fields, called dimensions. For example, lawsuit costs, a measure, can be grouped by department, a dimension. An aggregation is a computation based on multiple values in a data field, such as a sum or average. Continue reading