We are planning to upgrade the content form XIR3.1 to BO4 SP4.
We are planning to go for Incremental approach.
We have around 1000 Objects and 100 users. WebI reports and Universes.
I have some queries before we start the process:
1)Do i go for "Live to Live" or "BIAR to Live" if using incremental approach?
2) When I start upgrade with UMT do I have to stop the all the services (excecpt CMS,FTP,Tomcat) as I was reading the document for UMT and it says I have to stop all the services.
3) If answer to above question is Yes then do I stop the services in both systems i.e XIR3.1 and BO4.0 untill upgrade process is done?
4) Can I upgrade without stoping services, and just make that folder unavailable for the time untill upgrade is done?
5) I have amny WebI reports with "CUSTOM SQL", are there any major issues with upgrading of WebI reports with "Custome SQl"?
Please let me know your inputs so that I can finalize the process and approach based on live experiences!!