Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
light_wt@hotmail.com
Starting Member
2 Posts |
Posted - 2008-10-09 : 19:01:33
|
I have a large dimension in the Analysis Service. It reads data from a view in SQL server over the network.a select of that view locally takes about 6 min to finish. there are about 4 million rowsa select of that view from the AS box takes about 18 min to finish (3x the time compare to local).is there a way to speed up the AS to process that dimension?thanks. |
|
|
|
|