An Aggregate Measurement object is to actually create and link the measure and dimensions that you will use for analytics. The measure will be something you create and it will be a sum or a count of data. The dimension will be something you slice the measure by. This is the basic concepts in a star analytics schema. For example, you may want customer data, yet you don’t want all 10 tables of fields or standard data entities to get the data. You would like a single data entity that brings the information together with fewer fields or data points. It is much more useful with an application like Power BI where you can use the aggregate information in a graphical form easily. What is a Measure? The measure is the easy part. This is the numerical values that quantify the data set that you are digging into to understand better. So if you are looking at sales by employee, then “sales” is the measure and employees are the dimension. What is a Dimension? A dimension is...
DYNAMICS 365 FINANCE AND OPERATIONS