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





<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

<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>





<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

<Catalog>Sales Hourly</Catalog>

<MdxMissingMemberMode>Error</MdxMissingMemberMode>

<LocaleIdentifier>1033</LocaleIdentifier>

<DbpropMsmdMDXCompatibility>2</DbpropMsmdMDXCompatibility>

</PropertyList>

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." <jesperzz (AT) hotmail (DOT) com> wrote

Not sure what you mean by Request Type...

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




"Adrian Dumitrascu" <adumitrascu (AT) hotmail (DOT) com> wrote

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." <jesperzz (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:uh%23pCV6mGHA.732 (AT) TK2MSFTNGP04 (DOT) phx.gbl...

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.nospam (AT) diacom-systemhaus (DOT) nospam.de> wrote

Hi, Jesse

there was a write error in my query

Here is correceted one.

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<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." <jesperzz (AT) hotmail (DOT) com> wrote

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." <jesperzz (AT) hotmail (DOT) com> wrote

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_...-XMLA-query.ht

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

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_...-XMLA-query.ht

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

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_...-XMLA-query.ht

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