My Spotfire .dxp file won't open after Database URL was changed.
My report has one of the data table configured as Linked to source. Now after the DB URL was changed I am unable to open the report as it is continuously asking for userID/Password. If I cancel it closes the complete report loading process. Other reports had data tables configured as embedded and I was able to replace teh data table after opening the reports. But this one report had data table marked as linked to source and it does not work.
I had also tried the following -
1. Rename .dxp file to .zip
2. Edit the Analysis.xml file to point to correct data source.
3. Zipped the modified package and rename as .dxp.
But the above process fails in opening the file, error is thrown.
Can you please help me resolve the issue.