This project has moved. For the latest updates, please go here.

ASSP.DMV

Jul 21, 2009 at 2:07 PM

Hello guys,

I've got a problem with the following query:
CALL ASSP.DMV("SELECT DIMENSION_NAME,DIMENSION_IS_VISIBLE FROM $SYSTEM.MDSCHEMA_DIMENSIONS")
I get all dimensions with it's visible status.
In my cube is one dimension invisible and all other were visible.
The result of the query above shows that all dimensions were visible.

I get only "TRUE"'s.

Have someone the same issue? Have anybody an explanation for me?

Thanks!
Alex

Coordinator
Jul 22, 2009 at 1:31 AM

I believe that this is how Microsoft designed the MDSCHEMA_DIMENSIONS rowset. It is built for use by client applications in order for them to be able to display the metadata that the current user is allowed to see. As such cube dimensions that have been hidden will not appear in the list at all. In SSAS 2008 this rowset appears to have been extended slightly in that any perspectives that are defined will show the dimensions that they are not using with the visible property set to FALSE. In SSAS 2005 this view only shows the visible dimensions in the cube and the related partitions. That makes the visible column pretty much redundant in 2005.

Finding out if there are any hidden dimensions is really only possible if you are an administrator. You can either do this through AMO or you could use the ASSP.DiscoverXmlMetadata() call.

eg.

CALL ASSP.DiscoverXmlMetadata("\Cube\Dimensions\Dimension")

Jul 22, 2009 at 9:01 AM
Edited Jul 22, 2009 at 9:02 AM

Hello dgobbell,

thanks a lot for your explanation & tip.
This is what I'm looking for.

Thanks!
Alex