1 Reply Latest reply on Mar 29, 2016 3:27 PM by Shawn Wallwork

    Replacing underlying tables in a data source

    Rupali Negi

      Hi I have a question regarding replacing data source.

      Actually I was using a oracle data source with few tables. I created my reports and dashboard on basis of those tables. Later I got to know that the underlying tables are changed and now I need to get data from different tables within same data source and need to create same reports out of them. Is this achievable to use same reports and changing the references or I need to build the reports from scratch with new set of tables??

      Any answer appreciated...!!

       

      Thanks

      Lucky

        • 1. Re: Replacing underlying tables in a data source
          Shawn Wallwork

          Sort of depends on what is 'different' in you new tables. If the field names are the same, and just the data has changed, then you can Edit the Data Source and point it at the new tables. If they are not the same, but they're similar, then you are going to have to hunt down the errors and fix them. (Replace Reference is a handy tool for this.) The other option is to create a new connection and then Replace the old one with the new one.

           

          It really comes down to how different the tables are. Which is going to take longer, fixing errors or rebuilding the dashboards.

           

          Cheers,

           

          --Shawn