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 and ConWHSVehicleServiceLine as a child data source, as shown in the following screenshot:

3. Either set Use Relations property on the ConWHSVehicleServiceLine data source, or add a relation manually.
4. Add all non-system fields from the ConWHSVehicleServiceTable table, and the ItemId field from ConWHSVehicleServiceLine.
5. Save and close the view.

We can now create the aggregate measure, which...