Cube issue in SM
I had previously installed the SM Data Warehouse and SM Reporting server on the same box but installed the databases on the SQL server that hosted the servicemanagement and servicemanager databases.
Since I was having some issues with reporting and the Data Warehouse components missing from SM Console, I redid the Data Warehouse server.
I reinstalled The Data Warehouse services and this time left the databases pointing to itself instead of the other SQL.
the components are back but the Cubes are having issues. I was looking at the Data WareHouse server and see that the DWASDataBase Data Sources are still pointing to the old databases on the other SQL. Should I change the Server Name in that path to the New Data WareHouse server name and will that have any negative impact to the SM?