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.
Thanks again,


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |