In the previous post we created new data entities and import our sample data. In this post we’ll create a query and a view. The Aggregate measure will use the view as it’s data source. In this example as we created new tables we created all the objects but if you are using existing tables then this is where you would likely start to create your own query and views to pull together the data you want to include in the aggregate measurement.

Here is a quick overview.

D365 July 2017 Update 8 (7.0.4565.16211)

In the next post we’ll actually create the aggregate measurement.

Cheers

Lachlan


Filed under: Business intelligence