Creating aggregate data entities

Aggregate data entities allow us to use aggregate measures in the same way we would use a table. They can also be used to expose the aggregate data through OData. This example will be used to create a chart form part in the next recipe.

Getting ready

We will need an aggregate measure for this, so we are following on from the previous two recipes.

How to do it...

To create the aggregate data entity, follow these steps:

1. Create new item by choosing Analytics from the left pane of the Add New Item dialog and Aggregated Data Entity from the right. Name the entity ConWHSVehicleServiceDataEntity.
2. Drag the ConVehicleServiceMeasure aggregate measure to the DataSource node.
3. Expand the Measures node and drag all three measures to the Fields node.
4. We can also add dimensions as fields; in our case, we will need the ServiceDate dimension. Drag ServiceDate to the Fields node.
5. To make this more useful as an aggregate data entity, we will choose a specific attribute of this dimension...