AS2000. How to organize pocessing?

in 2000 made update processing off dimension , full processing of last partition in every cube. made in transaction. duering processing old version of data available mdx querying.

if i do same in 2000, database seem locked.

what make wrong?

hiere xmla batch send as2005.

<batch transaction="true" processaffectedobjects="true" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<parallel>

<process xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

<object>

<databaseid>mw</databaseid>

<dimensionid>abteilung</dimensionid>

</object>

<type>processupdate</type>

</process>

 

<process xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

<object>

<databaseid>mw</databaseid>

<dimensionid>adm</dimensionid>

</object>

<type>processupdate</type>

</process>

 

<process xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

<object>

<databaseid>mw</databaseid>

<dimensionid>artikel</dimensionid>

</object>

<type>processupdate</type>

</process>

<process xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

<object>

<databaseid>mw</databaseid>

<cubeid>verkauf</cubeid>

<measuregroupid>verkauf</measuregroupid>

<partitionid>verkauf_2006</partitionid>

</object>

<type>processfull</type>

</process>

 

<process xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

<object>

<databaseid>mw</databaseid>

<cubeid>verkauf</cubeid>

<measuregroupid>verkaufauftrag</measuregroupid>

<partitionid>verkaufauftrag_2006</partitionid>

</object>

<type>processfull</type>

</process>

 

<process xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

<object>

<databaseid>mw</databaseid>

<cubeid>verkauf</cubeid>

<measuregroupid>verkaufrechnung</measuregroupid>

<partitionid>verkaufrechnung_2006</partitionid>

</object>

<type>processfull</type>

</process>

 

<process xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

<object>

<databaseid>mw</databaseid>

<cubeid>verkauf</cubeid>

<measuregroupid>verkaufartikel</measuregroupid>

<partitionid>verkaufartikel_2006</partitionid>

</object>

<type>processfull</type>

</process>

</parallel>

</batch>

do mean "if i do same in 2005, database seem locked" ?

if related analysis services 2005 behvior, strange. think should have access product support. please report problem.

thanks.

edward melomed.
--
this posting provided "as is" no warranties, , confers no rights. 

SQL Server  >  SQL Server Analysis Services