ROOT CHECK

Update: If following method is not working have a look at this  Changes in SQL Script to restore bacpac file for D365FO Many times to debug the Production environment issues we might need live data to address that issue in such case first of all we need to refresh the UAT/Sandbox database with the Production environments database and then afterward we need to export the UAT database to the Asset library from where we can get bacpac file for that UAT database which is then to be imported in your cloud-hosted or one-box environment. This blog and video demonstration will help you to restore your production or UAT database to a cloud-hosted environment. Step 1: Rename existing db  In this step, we need to rename the existing AxDB for safety purposes. Just go to the SSMS application and execute the following command:-   ALTER DATABASE [ip_ent_site] SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO ALTER DATABASE [ip_ent_site] MODIFY NAME = [ip_ent_site_new] GO ALTER DATABASE [ip_ent...

   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!