Building a measure to publish to the entity store – Part 6

In our last post we created the query and the view. In this post we’ll now get to the aggregate measure. If you already had a view that you know has the data you need then obviously you would skip right to this point and create a new measure.

The point of the aggregate measure 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.

Here is a quick overview.

D365 July 2017 Update 8 (7.0.4565.16211)

 

Once you have the measure then you can use it in Power BI desktop. From there you can published to Power.com and allow users to access it in the application. You can see how this works with the standard reports models in this post.

Cheers

Lachlan

3 responses to “Building a measure to publish to the entity store – Part 6

  1. Pingback: Building a measure to publish to the entity store – Part 5 | OrganicAX·

  2. Pingback: Building an aggregate data entity to access a measure via Odata | OrganicAX·

  3. Pingback: Building an aggregate data entity to access a measure via Odata - Microsoft Dynamics AX Community·

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s