To create the aggregate data entity, follow these steps:
- 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.
- Drag the ConVehicleServiceMeasure aggregate measure to the DataSource node.
- Expand the Measures node and drag all three measures to the Fields node.
- We can also add dimensions as fields; in our case, we will need the ServiceDate dimension. Drag ServiceDate to the Fields node.
- To make this more useful as an aggregate data entity, we will choose a specific attribute of this dimension. Set the Attribute property to Month.
- This aggregate data entity should be grouped by vehicle; to add the Vehicle ...