Has anyone attempted to model (hopefully a Star Schema) the Dynamic Management views (DMV) metadata into a report? I’d like to create a template model/report which can be ran on a given XMLA Endpoint and Database so that when a report is deployed, we can also release a DMV report alongside it.
1 Like
Hi @ClarkeM ,
Thank you for reaching out to the community.
While we wait for other members to share their insights, we’ve taken the liberty of using “Explain Simply ,” one of the tools available within Data Mentor (you can explore it here: https://mentor.enterprisedna.co/explain-simply . It generated the following results:.
Feel free to checkout more of our Data Mentor features as you work on your report. These tools are designed to help with tasks like the one you’re working on.
Cheers,
Enterprise DNA Support Team
Hello,
What do you need to know?
In the company where I work, we are using DMV to get the metadata. All our dataset are published to the same workspace. When deploying a new dataset, it is automatically to the DMV report.