I have an 2xXeon 3.6 with Win 2003 Srv, SQL & AS 2000 SP4.

I have an cube with 2 dimensions (Customer and Articles, parent - child
definition. Customer: 3 levels, Articles up to 7 levels)

I use this cube for planning, so it's write enabled (i need the aggregations
realtime.). The Writeback table is in SQL srv.
Writing into cubes is fast enough and is working fine. This means that also
the agregation are made quick when I save the data.

The problem is when I read the data. For example when I browse the data in
Analysis Manager when I open an level it is taking up to 10secs. I have seen
with the Profiler what's happened in the SQL srv and I've seen that AS is
generating an *starnge* sqlstatment (called with the sp_prepexec). This
statement has up to 3000 - 4000 parameters . It should be like this ???


Any ideea how can I improve the read performance of this write enable cube ?

Thanks,
Radu