hi all!

we are using a writable cube for budgeting purposes. the write table has
around 40.000 records now. when we open the cube after processing, it takes
around 5-10 mins to display the values. afterwards response time is ok, but
still not perfect. is there a way to optimize this without cleaning the
write table? could it help to change the fill-factor on the indexes msolap
automatically configures?

greetings
ref

I think it's best to convert writebacks to partition periodically.

Ohjoo Kwon


"ref" <re_f (AT) yahoo (DOT) com> wrote

yes, thanks, this is what i did. after all its responding normally again.
crazy that msolap does not automaticaly include this data during cube
processing, but on runtime.

"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> schrieb im Newsbeitrag
news:eY5R%23HKKFHA.2796 (AT) tk2msftngp13 (DOT) phx.gbl...