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.