MB-500: Microsoft Dynamics 365: Finance and Operations Apps DeveloperDemo

By Microsoft · Question Mode

QuestionQ285

Implement reporting

You are a Dynamics 365 Finance developer.

The sales department manager needs to view total customers by region and total sales by region. You must build key performance indicators (KPIs) and show them on an application tile.

How should you model the KPI? Each object can be used once, more than once, or not at all.

Drag & Drop
Aggregate dimension
Aggregate data entity
Aggregate measurements
Explanation

Per the Dynamics 365 analytics model, an aggregate measurement is a model that holds measures (aggregate numbers such as Total Sales or Number/Count of Orders) together with their dimensions, while an aggregate dimension is a shared slicer used to analyze a measure. Both "total sales" and "total customers" are aggregate numbers, so each is modeled as a measure inside Aggregate measurements. "Region" is the slicer used to break those numbers down, so it is modeled as an Aggregate dimension. The original key incorrectly modeled "customers" as a dimension, but a count of customers is a measure, not a slicer.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!