May 2017
Intermediate to advanced
442 pages
11h 55m
English
The aggregate measure defines the values we wish to display and the dimensions by which we will filter and splice the data. It may seem odd that we don't have measures such as VehiclesServicedThisYear, but this isn't a function of a measure. This is accomplished by a combination of the ServiceDate dimension and the Vehicles measure.
The entity refresh creates and maintains the data in the data warehouse database. This is AxDW on development environments, and for the cloud deployed sandbox, you will get this from LCS.
If you open the SQL Server Management Studio, the tables are created as follows:

You can query this data to ...
Read now
Unlock full access