Help with XMLA query

Jesse O.

unread,

Jun 29, 2006, 1:55:49 PM6/29/06

to

I have the following captured from a trace event. I'd like to run it within
Management Studio.

When I attempt to run it as XMLa, it throws the following error. Any tips to
get it to run? I'm new to XMLA.

Executing the query ...

The RestrictionList element at line 7, column 134 (namespace
urn:schemas-microsoft-com:xml-analysis) cannot appear under
Envelope/Body/Execute/Command.

Execution complete

<CATALOG_NAME>Sales Hourly</CATALOG_NAME>

<CUBE_NAME>Sales</CUBE_NAME>

<MEMBER_UNIQUE_NAME>[Sales].[Ad Category Drilldown].[All Ad Category].[
Subtotal]</MEMBER_UNIQUE_NAME>

<TREE_OP>8</TREE_OP>

</RestrictionList>

<Catalog>Sales Hourly</Catalog>

<MdxMissingMemberMode>Error</MdxMissingMemberMode>

</PropertyList>

Adrian Dumitrascu

unread,

Jun 29, 2006, 2:26:41 PM6/29/06

to

The restrictions list appear in a Discover statement, for example:

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_METADATA</RequestType>
<Restrictions>
<RestrictionList>
<ObjectExpansion>ExpandObject</ObjectExpansion>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<Timeout>0</Timeout>
<SspropInitAppName>Microsoft SQL Server Management
Studio</SspropInitAppName>
<LocaleIdentifier>1033</LocaleIdentifier>
<ClientProcessID>3184</ClientProcessID>
</PropertyList>
</Properties>
</Discover>

You also need to know the RequestType. You mentioned you got the
RestrictionsList and the PropertiesList from a trace event. Does that event
also provides the RequestType ?

Adrian

"Jesse O." <jesp...@hotmail.com> wrote in message
news:uh%23pCV6m...@TK2MSFTNGP04.phx.gbl...

Jesse O.

unread,

Jun 29, 2006, 2:38:53 PM6/29/06

to

Not sure what you mean by Request Type...

I didn't see it caputued in the trace anywhere.

"Adrian Dumitrascu" <adumi...@hotmail.com> wrote in message
news:eu3JSm6m...@TK2MSFTNGP03.phx.gbl...

Vladimir Chtepa

unread,

Jun 30, 2006, 8:00:49 AM6/30/06

to

Hi Jesse,

what MDSCHEMA do you descover? MDSCHEMA_MEMBERS? Then you request schould
have following form.

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_METADATA</RequestType>
<Restrictions>
<RestrictionList>

<CATALOG_NAME>Sales Hourly</CATALOG_NAME>
<CUBE_NAME>Sales</CUBE_NAME>
<MEMBER_UNIQUE_NAME>
[Sales].[Ad Category Drilldown].[All Ad Category].[Subtotal]
</MEMBER_UNIQUE_NAME>
<TREE_OP>8</TREE_OP>
</RestrictionList>

</Restrictions>
<Properties>
<PropertyList>

<Catalog>Sales Hourly</Catalog>
<MdxMissingMemberMode>Error</MdxMissingMemberMode>
<LocaleIdentifier>1033</LocaleIdentifier>
<DbpropMsmdMDXCompatibility>2</DbpropMsmdMDXCompatibility>
</PropertyList>

</Properties>
</Discover>

"Jesse O." <jesp...@hotmail.com> schrieb im Newsbeitrag
news:uh%23pCV6m...@TK2MSFTNGP04.phx.gbl...

Jesse O.

unread,

Jun 30, 2006, 5:15:59 PM6/30/06

to

Thanks again for your continuted help Vladimir.

When running the query, I receive the following error, any ideas?

And yes, It's 10 - MDSCHEMA_MEMBERS

Executing the query ...

XML for Analysis parser: The restriction, CATALOG_NAME, is not recognized by
the server.

Execution complete

"Vladimir Chtepa" <vc.n...@diacom-systemhaus.nospam.de> wrote in message
news:OoNaVzDn...@TK2MSFTNGP04.phx.gbl...

Vladimir Chtepa

unread,

Jul 1, 2006, 6:24:12 PM7/1/06

to

Hi, Jesse

there was a write error in my query

Here is correceted one.

<RequestType>MDSCHEMA_MEMBERS</RequestType>
<Restrictions>
<RestrictionList>

<CUBE_NAME>Sales</CUBE_NAME>
<MEMBER_UNIQUE_NAME>
[Sales].[Ad Category Drilldown].[All Ad Category].[Subtotal]
</MEMBER_UNIQUE_NAME>
<TREE_OP>8</TREE_OP>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<Catalog>Sales Hourly</Catalog>

</PropertyList>
</Properties>
</Discover>

"Jesse O." <jesp...@hotmail.com> wrote in message
news:eHzMjpIn...@TK2MSFTNGP02.phx.gbl...

Igor

unread,

Jul 4, 2006, 6:03:18 AM7/4/06

to

1. I think that you are off topic - there is:
microsoft.public.data.xmlanalysis
2. Try this free tool: http://sourceforge.net/projects/whex
It has an option to run the tool from the command line which prints every
SOAP message to the console.
Maybe that will help you in your development.

Regards,

Igor

"Jesse O." <jesp...@hotmail.com> wrote in message

news:uh%23pCV6m...@TK2MSFTNGP04.phx.gbl...

Alex

unread,

Feb 14, 2008, 10:23:28 PM2/14/08

to

i want to use xmla query to get specified database's all partitions, including remote partitions(just like management studio provide the backkup options), how to write the xmla query?

thanks.

From http://www.developmentnow.com/g/112_2006_6_0_0_781376/Help-with-XMLA-query.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com