Monday, June 27, 2016

DMV Queries: To Get All Attributes in a cube

Use below Dynamic Management View (DMV) queries to get all the dimension and attributes of your cube

SELECT
       [CATALOG_NAME] as [Database],
       CUBE_NAME AS [Cube],
       [DIMENSION_UNIQUE_NAME] AS [Dimension],
       HIERARCHY_DISPLAY_FOLDER AS [FOLDER],
       HIERARCHY_CAPTION AS [DIMENSION ATTRIBUTE],
       HIERARCHY_IS_VISIBLE AS [VISIBLE]
FROM
       $system.MDSchema_hierarchies
WHERE 
       CUBE_NAME  ='My Cube Name' AND 
       HIERARCHY_ORIGIN=2
ORDER BY
       [DIMENSION_UNIQUE_NAME]
 
Note: Replace 'My Cube Name' with your cube name

4 comments:


  1. Awesome article. It is so detailed and well formatted that i enjoyed reading it as well as get some new information too.


    SAP ABAP training in Chennai

    ReplyDelete
  2. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.

    seo training in chennai

    ReplyDelete
  3. Such a great articles in my carrier, It's wonderful commands like easiest understand words of knowledge in information's.
    GRE Coaching in Chennai

    ReplyDelete
  4. Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.

    Fresher Jobs in Chennai
    Fresher Jobs in Delhi
    Fresher Jobs in Bangalore
    Fresher Jobs in Kolkata

    ReplyDelete