Is it Possible to Activate the MultiProvider in the Production system?
The important thing is without affecting the Reports.
Yes you can Activate the Multiprovider in the Production system Directly without affting the Reports.
Use this Function Module : RSDG_MPRO_ACTIVATE
You try first it on Sandbox, development system before attempting on production environment.