ROOT CHECK

In D365 there are several option to export/Import data like Data Entities, BYOD, Aggregate measurements/Entity store. In this blog we will learn How to create entity store in D365 Finance and operations. Aggregate Measurements/Entity Stores are use to create Power Bi reports with nearly Live data where user have option to set its recurrence that is how often you want to refresh entity store there is no need to manually refresh the data as per suggested Batch job will run for respective entity stores. You can also forcefully refresh data by pressing refresh button on entity store page. So lets start with development of aggregate measurements, aggregate dimensions. Add New aggregate measurements object to the project where we required Add required attributes Add required measures Add required dimensions Add dimensions where view of dimension and aggregate measurements are different Build The Model Refresh Entity store from D365 Finance and Operation Environment Verify that r...

   In my case I developed aggregate measures and its respective aggregate dimensions.But after development aggregate dimensions which was attached to aggregate measurements were not reflected in ssms as views as you can see in following screenshots. To resolve this issue build project that contains the respective aggregate measurement after which just navigate to System administion >>  Setup >> Entity store and refresh the respected entity by clicking refresh button. Even after this respected view is not visible in SSMS navigate to System administration >> Inquiries >>  Batch Jobs and now search for "full reset" batch job and change its status to waiting. If you don't know how to change the status of batch job you can refer to this  link after this step again try to refresh entity store as mentioned above and now check in SSMS you can find your respected view there. I hope this blog was helpful to you, thank you!