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

19 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
  5. That was a great message in my carrier, and It's wonderful commands like mind relaxes with understand words of knowledge by information's.
    Manpower Services in Chennai

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

    Digital Marketing Company in Chennai

    ReplyDelete
  7. This is extremely great information for these blog!! And Very good work. It is very interesting to learn from to easy understood. Thank you for giving information. Please let us know and more information get post to link.

    Oracle Training in Chennai

    ReplyDelete
  8. After looking into a handful of the blog articles on your site, I really like your technique of writing a blog. I book marked it to my bookmark site list and will be checking back in the near future. Take a look at my website as well and let me know your opinion.
    Web Designing Training in Chennai
    VMware Training in Chennai
    Software Testing Training in Chennai

    ReplyDelete
  9. I do believe all of the concepts you’ve introduced in your post. They’re very convincing and will definitely work. Nonetheless, the posts are too short for novices. May you please extend them a bit from subsequent time? Thank you for the post.
    Hadoop Training in Chennai
    Informatica Training in Chennai
    iOS Training in Chennai

    ReplyDelete
  10. Excellent goods from you, man. I’ve understand your stuff previous to and you’re just too excellent. I actually like what you’ve acquired here, certainly like what you are stating and the way in which you say it. You make it enjoyable and you still take care of to keep it sensible. I can not wait to read far more from you. This is actually a tremendous site..
    Office Interior Designers in Coimbatore
    Office Interior Designers in Bangalore
    Office Interior Designers in Hyderabad

    ReplyDelete
  11. Really Good blog post about DMV queries to get all attributes in cube.provided a helpful information.I hope that you will post more updates like this.
    Digital marketing company in Chennai

    ReplyDelete
  12. Thanks for spending your valuable time in delivering the most valuable content here.I loved the way you write and suggest my friends too for getting aware of your blogs.
    Pawn Shops in Montgomery
    Pawn Shops in Birmingham
    Pawn Shops in Mobile

    ReplyDelete
  13. Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

    Digital Marketing Company in India
    Web Development Company in India
    Web Design Company in Chennai
    Android app development company in Chennai

    ReplyDelete
  14. This comment has been removed by the author.

    ReplyDelete
  15. wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much
    SEO Training in Chennai

    ReplyDelete
  16. i really like this blog.And i got more information's from this blog.thanks for sharing!!!!
    Iperidigi
    SEO Company in Chennai
    SEO Company in India

    ReplyDelete
  17. this is very nice blog this studying course information very useful to everyone who have learning this information.this education information is very helpful to start my carrier with technology.

    Base SAS Training in chennai

    ReplyDelete
  18. It's a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much.

    Allergy Medicines
    Ayurvedic Medicine For Immunity
    Hyperpigmentation cream
    Viral Fever Medicines

    ReplyDelete