I have writeback-enabled my cube, but when I try to update a value from Reportportal the DLLHost-process spins out of control an completely freezes the server.
Anyone have the same experience and if so, how did you resolve it?
Analysis Service writes back data down to fact grain level. This means that when write back to a high-level tupple AS can create a big number of inserts.
By the way which database are you writing to Access or SQL Server?
I use an SQL Server 2000 SP3. My fact table contains some 500.000 rows, wich sounds like a lot, but really isn't.
It seems that if I drill down to an aggregation level which only contains a few rows, the server still hangs... And no data ends up in the write-back table...
Report Portal
Writeback to Qube
Posted - 09/21/2005 : 09:42:04
