Hello,

I am having huge trouble to activate writeback. I checked the Foodmart
examples and loaded the Excel sample from mosha.com which all works fine.

Not the I have a cube which I can access all right in reading. Only
difference to the Foodmart example seems to be that all fact /dimension
tables are in SQL Server, not MS-Access. I can write-enabled it, and the
writeback table is created correctly.

Now I issue the update statement, and everything goes to 100% CPU and the
system is basically hanging (until I shut down after 5 min). I tried this via
PivotTable Services from Excel, and directly via ADO from an .asp page.

I get no error message, there is nothning in any logs. Only strange thing I
observe is frequent errors of MSSQLServerOLAPService "Relational data
provider reported error: [sp_trace_setstatus]." in the Application Event log.

The MDX Statement:
Update cube [MM4] set ([Measures].[MM Units],[SellingPlant].[Selling
Plant].[Barsinghausen, DE],[PartType].[All Part
Description].[Valve],[PartNumber].[All Trwpart Number].[V Task
IE],[Time].[All Year].[2005].[2005-Q1].[01])=12 Use_Equal_allocation

The fact table has 186 k rows. This statement would maybe affect 10000 rows.

Any ideas welcomed!
Thanks, Rafael