Hi all

I have a very large dimension and it takes more than 2 hours in
Process Update. So I need to use procedssadd method to process
dimensions.

But the problem is that whatever condition I specify when I process the
cube Analysis Service ignores the where condition. It just process all
the data instead of processing only specified data.
I can not see any where clause in the query during dimension process.

Is this a bug or I am doing something wrong?

My code for ProceddAdd is as below

<Batch Transaction="1" ProcessAffectedObjects="0"
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">


<Process
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>
<DatabaseID>test</DatabaseID>
<DimensionID>t</DimensionID>
</Object>
<Type>ProcessAdd</Type>
</Process>

<DataSource xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:type="RelationalDataSource">
<ID>Test</ID>
<Name>Test</Name>
<ConnectionString>Provider=SQLNCLI.1;Data Source=(local);Integrated
Security=SSPI;Initial Catalog=Test</ConnectionString>

<Timeout>PT0S</Timeout>
</DataSource>
<DataSourceView>
<ID>test</ID>
<Name>test</Name>
<DataSourceID>test</DataSourceID>
<Schema>
<xs:schema id="test" xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
<xs:element name="test" msdata:IsDataSet="true"
msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="dbo_t" msprop:FriendlyName="t"
msprop:QueryBuilder="SpecificQueryBuilder" mspropbTableName="t"
msprop:QueryDefinition="SELECT id&#xD;&#xA;FROM
t&#xD;&#xA;WHERE (id &gt; 35)" msprop:TableType="View"
msprop:IsLogical="True">
<xs:complexType>
<xs:sequence>
<xs:element name="id" msprop:FriendlyName="id"
mspropbColumnName="id" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
</Schema>
</DataSourceView>


</Batch>

Got it resolved in SP2 CTP, but it also takes about 70% time of process
default.

Thanks all.

sqlprobs (AT) gmail (DOT) com wrote: