ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
olalarsson	Posted - 09/21/2005 : 09:42:04 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? Ola
4 L A T E S T R E P L I E S (Newest First)
olalarsson	Posted - 09/23/2005 : 06:30:55 hehe... it hangs! ;) Thanks for the input though
admin	Posted - 09/22/2005 : 07:10:51 Please open MDX Sample Application and try following statements: 1) BEGIN TRANSACTION 2) UPDATE CUBE [CubeName] SET (Member1, Member2) = 1000 You can read more about the UPDATE CUBE syntax here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/pt_prddldml_06wk.asp 3) COMMIT TRANSACTION
olalarsson	Posted - 09/21/2005 : 14:45:44 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... Ideas?
admin	Posted - 09/21/2005 : 14:12:31 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?

ReportPortal