Tuesday, 21 February 2017

XMLA Query to get the Cube MetaData


<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
  <RequestType>DISCOVER_XML_METADATA</RequestType>
  <Restrictions>
  </Restrictions>
  <Properties>
    <PropertyList>
      <Catalog>Adventure Works DW 2008R2 SE</Catalog>
    </PropertyList>
  </Properties>
</Discover>

Other Options

DISCOVER_DATASOURCES  
DISCOVER_ENUMERATORS 
DISCOVER_KEYWORDS  
DISCOVER_LITERALS  
DISCOVER_PROPERTIES 
DISCOVER_SCHEMA_ROWSETS  
"We can't solve problems by using the same kind of thinking we used when we created them - Albert Einstein"

No comments:

Post a Comment