Creating aggregate measures

These can be thought of as cubes from prior releases of Operations and form that basis to which we analyze our data. They contain the aggregate data that the dimensions splice or pivot on.

Getting ready

You may find that the drop-downs used in properties may not work in this recipe; to resolve this, simply build the project before you start.

How to do it...

First, we will need to create a view that flattens the service data into one view. To do this, follow these steps:

1. Create a new view called ConWHSVehicleServiceExpanded.
2. Add the ConWHSVehicleSErviceTable table as the root data source...