2

Retrieving XMLA to analyze cube structure

Below are instructions on how to get the cube structure (dimensions, hierarchies, measures…)

It can help the Pyramid development team debug cases where the query fails to get the cube metadata.
 

Steps:

In Microsoft SQL Server Management Studio, connect to the analysis server for the relevant cube/model.

Run the below two XMLA queries, 

Send the two queries results to the Pyramid support team for further analysis.
(Below is an example image)

This is the first query to run:

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">

       <RequestType>DISCOVER_XML_METADATA</RequestType>

       <Restrictions>

              <RestrictionList>

                     <ObjectExpansion>ExpandObject</ObjectExpansion>

              </RestrictionList>

       </Restrictions>

       <Properties>

              <PropertyList>

                     <CONTENT>Data</CONTENT>

              </PropertyList>

       </Properties>

</Discover>

Copy the first result in a notepad, to send it to us.
Now, In the result, please look for this segment:
 

<Database>

              <Name>Pyramid Demo 2013</Name>

              <ID>Pyramid Demo 2013</ID>

              <CreatedTimestamp>2010-12-26T07:04:30</CreatedTimestamp>

              <LastSchemaUpdate>2013-12-03T07:46:23.46</LastSchemaUpdate>

              <LastProcessed>2015-09-01T11:12:36.416667</LastProcessed>

              <State>Processed</State>

              <LastUpdate>2019-03-31T15:34:31.616667</LastUpdate>

</Database>


The <Name> tag contains the name of the model you're trying to open.
The <ID> tag holds a value you'll need for the next query.
Take the value and use it in the <DatabaseID> tag of this next query and run it.
 

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">

       <RequestType>DISCOVER_XML_METADATA</RequestType>

       <Restrictions>

              <RestrictionList>

                     <DatabaseID>Pyramid Demo 2013</DatabaseID>

              </RestrictionList>

       </Restrictions>

       <Properties>

              <PropertyList>

                     <CONTENT>Data</CONTENT>

              </PropertyList>

       </Properties>

</Discover>


Copy the second result in the notepad as well and send both results back to the Pyramid support team.

 

 

Reply

null