SSAS 2008: Displaying Hierarchical data from DMVs

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.

Print | posted on Friday, February 22, 2008 7:29 AM