Full cube processing. | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Full cube processing.I have setup a test Analysis and DB Server. I was wondering, how could i do a full processing of my cube pointing to the test server and not the production? Is there a setting on the AS Server, where i point to my test db server not the prod?
Appreciated if someone please suggest.
Open SSMS, connect to AS server and then expand AS DB in LHS tree. Select the data sources folder and open the datasource created by right clicking on the same and select properties. Check the connection string and modify it to point it to your test server.
Thanks a lot. Followed what you suggested and it worked fine.