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 rows

a 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.

drop the view, and create table with same name and structure 

Create SSIS task for importing the data . Create schedule for executing it.