Extending Microsoft Dynamics 365 for Operations Cookbook

How to do it...

Dimensions should be based on views in order to denormalize the data. This is to let the users see name and description fields, and not the identity columns, so the first part is to create or extend a view to allow this data to be easily accessed.

To create the view, follow these steps:

1. Create a new view called ConWHSVehicleTableExpanded.
2. Add the ConWHSVehicleTable table as the root data source, and ConWHSVehicleGroup as a child data source, as shown in the following screenshot:

3. Either set the Use Relations property on the ConWHSVehicleGroup data source, or add a relation manually.
4. Add all non-system fields from the ConWHSVehicleTable ...