I'm having difficulty finding examples of using ProcessAdd to update a
dimension. I found one comment in "Applied Microsoft Analysis Services" that
says that it only works on single-table dimensions, which is somewhat
limiting, but still adds value.

The only XMLA example I can find is from the 2005 processing architecture
document
(http://msdn.microsoft.com/sql/bi/ana...sprocarch.asp),
but this sample (see below) is not complete. It includes an msprop namespace
which is not defined, and an xs namespace which is not defined.

Can someone please post a working ProcessAdd XMLA example?

<Process xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>Adventure Works DW</DatabaseID>
<DimensionID>Dim Customer</DimensionID>
</Object>
<Type>ProcessAdd</Type>
<DataSourceView>
<ID>Adventure Works DW</ID>
<Name>Adventure Works DW</Name>
<DataSourceID>Adventure Works DW</DataSourceID>
<Schema>
...
<xs:element name="dbo_DimCustomer" msprop:QueryDefinition="SELECT
* FROM DimCustomer WHERE CustomerKey > 29483"
mspropbTableName="DimCustomer"
msprop:IsLogical="True"
msprop:TableType="View">
...
</Schema>
</DataSourceView>
</Process>


Thanks,

--
SmartGuy

msprop and xs namespaces are defined in a typical DSV. Just do "view source"
of any DSV and you should see them defined.

Essentially the snippet in the document is indicating to "paste" a good DSV
in that part of the request...

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"SmartGuy" <SmartGuy (AT) discussions (DOT) microsoft.com> wrote