SSAS 2008: Displaying Hierarchical data from DMVs

<< SSAS 2008: What's new in the Schema Rowsets? | Home | SSAS 2008 - small DMV improvement >>

I just noticed an interesting thing about the schema rowsets when queried using the new DMV syntax and that is that you can drill into hierarchical data - cool.

This probably comes out of building the DMV syntax on top of DMX which seems to make a bit of use of nested tables.

Share This Post:
Short Url: http://wblo.gs/VBL

Feedback

No comments posted yet.

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.

Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

NetworkedBlogs

Blog:

Random Procrastination

Topics:

MDX, SQL Server, BI

Follow my blog

Twitter

darrengosbell @mtydeman sorry, was not on twitter last week. Yes, SSAS MD works well with snowflakes. The joins are resolved during dimension processing about 12 days ago

darrengosbell SSAS: Clearing the MDX Script for a session in SSMS http://t.co/jioE6bQO about 112 days ago

darrengosbell SSAS: Executing MDX Scope statements using SSMS http://t.co/Tpx9pfoz about 157 days ago

darrengosbell @MitchDenny thanks - I had a ball, #powerview is such a cool thing to demo about 248 days ago

darrengosbell @asantaballa @jenstirrup daxeditor is not me, that's an MS sample. I'm working on http://t.co/b1JsRLps at the moment about 305 days ago

darrengosbell @Technitrain I can see it too about 305 days ago

darrengosbell @jppp I hope you enjoy the 2012 release :) life's been pretty good - too busy, but still good. about 430 days ago

darrengosbell BIDS Helper 1.6 Beta Release (now with SQL 2012 support!) http://t.co/dSWkG7PI about 430 days ago

darrengosbell @Kjonge just showed that in post-ctp3 #denali #Dax in #ssas will have query plans as profiler events about 588 days ago

darrengosbell Really hard choice for this timeslot @Kjonge, @jenstirrup & @marcorus all have sessions at the same time. Lucky I ordered the DVDs #sqlpass about 588 days ago

Darren Gosbell [MVP] - Random Procrastination

Business Intelligence, SQL Server, .Net, Powershell and MDX Madness