skip to main | skip to sidebar

Carlos Klapp's Code Blog

All software and software code is released under the BSD license (http://www.opensource.org/licenses/bsd-license.php), unless otherwise specified or if the code is part of a project governed by another license. All trademarks are owned by their respective companies and/or individuals.

Friday, July 19, 2013

MDX query to list all dimension attributes

/*

http://msdn.microsoft.com/en-us/library/ms126309.aspx
http://ssas-wiki.com/w/Articles#DMV_.28Dynamic_Management_View.29
http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/
http://www.ssas-info.com/analysis-services-faq/80-ssas-2008-dmvs/1342-analysis-services-2008-systemmdschema-dmvs-

*/


select
Property_Name
,Property_Caption
,*
from
$SYSTEM.MDSCHEMA_PROPERTIES
where
Property_Type = 1
and Cube_Name = 'The name of your cube'

Posted by Carlos Klapp at 3:37 PM No comments:
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2019 (2)
    • ►  April (2)
  • ►  2018 (2)
    • ►  November (1)
    • ►  March (1)
  • ►  2017 (1)
    • ►  September (1)
  • ►  2016 (1)
    • ►  March (1)
  • ►  2014 (1)
    • ►  December (1)
  • ▼  2013 (16)
    • ►  October (2)
    • ►  September (1)
    • ►  August (1)
    • ▼  July (1)
      • MDX query to list all dimension attributes
    • ►  April (2)
    • ►  March (5)
    • ►  February (3)
    • ►  January (1)
  • ►  2012 (3)
    • ►  November (3)
  • ►  2011 (10)
    • ►  October (1)
    • ►  September (3)
    • ►  August (3)
    • ►  March (2)
    • ►  February (1)
  • ►  2010 (12)
    • ►  December (2)
    • ►  November (2)
    • ►  October (2)
    • ►  May (2)
    • ►  April (1)
    • ►  March (2)
    • ►  January (1)
  • ►  2009 (10)
    • ►  December (1)
    • ►  October (1)
    • ►  August (1)
    • ►  July (1)
    • ►  June (3)
    • ►  March (2)
    • ►  February (1)
  • ►  2008 (12)
    • ►  August (2)
    • ►  April (1)
    • ►  February (3)
    • ►  January (6)
  • ►  2007 (15)
    • ►  December (1)
    • ►  October (2)
    • ►  September (11)
    • ►  August (1)

About Me

Carlos Klapp
I specialize in Business Intelligence (BI), data warehousing, ETL, SSIS, OLAP, MS SQL Server, reporting services, C#, and ASP.Net. Please direct contracting inquires to: CarlosKlappBiz AT gmail DOT com
View my complete profile
 
Copyright (c) 2007, Carlos Klapp

All rights reserved.

Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

  • Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.

  • Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.

  • Neither the name of the nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.


    • THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS"AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOTLIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FORA PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER ORCONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, ORPROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OFLIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDINGNEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THISSOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.