Cell Writeback.Error

[RajChinna]

Hi,

I am executing a cell writeback (without commit) to the
Sales cube in Foodmart 2000 using the following syntax:

Update Cube [Sales]
Set ([Customers].[All Customers].[USA].[CA].[Altadena],
[Education Level].[All Education Level].[High School
Degree],[Gender].[All Gender].[F],[Marital Status].[All
Marital Status].,[Product].[All Products].[Food].
[Canned Foods].[Canned Soup].[Soup].[Blue Label].[Blue
Label Turkey Noodle Soup],[Time].[1997].[Q1].[3],
[Measures].[Sales Count])= 50 Use_Equal_Allocation

The process runs for about 3 minutes (while it consumes
tremendous amounts of memory) and then for some
unexplained reason, the following error message is
generated:

Syntax error in expression, near: 'exec Update Cube
[Sales] Set ([Customers].[All Customers].[USA].[CA].
[Altadena],[Education Level].[All Education Level].[High
School Degree],[Gender].[All Gender].[F],[Marital Status].
[All Marital Status].,[Product].[All Products].[Food].
[Canned Foods].[Canned Soup].[Soup].[Blue Label].[Blue
Label Turkey Noodle Soup],[Time].[1997].[Q1].[3],
[Measures].[Sales Count])= 50 Use_Equal_Allocation

Suspecting it might be a memory issue and not a syntax
issue, I then ran the same update statement using a
slightly smaller cube (SalesSmall) that is identical to
the Sales cube but contains 2 less dimensions (I removed
the Promotions and Promotion Media dimensions). The same
syntax in the SalesSmall cube executed a writeback in
about 2 seconds and DID NOT generate the above error.

For testing purposes, I then created another cube
(SalesSmall1) where I added back the Promotions dimension
to the SalesSmall cube. Again, the same syntax executed a
writeback in about 15 seconds and DID NOT generate the
above error.

I ran a google search and could not find a reference to
this error. Can anybody explain this MDX error, confirm
that it is related to memory limits or cube size, and
possibly suggest a work around solution for executing cell
writebacks in larger cubes.

Many thanks,

Raj C.