Managing historical data

  • Hi all,

    I want to reuse existing report to another database with same tabular structure. However, I want to preserve historic data as well. I mean if i have to create new report I will need to write new queries but I just want to use same query with only change in database name. is there any precise way??

    Thanks in advance.

    Mg

  • you can copy the report and then use the same query but change the datasource to the new database.

  • Thank you for the reply. But in that case I have to manage two reports. let me describe my scenario in detail.

    I have two database. A and B

    previously I have been using A for my reporting. Now I want to use B database and also need to preserve historic reports from A. My reports are large so if i go through manual approach I have to change all the queries (i.e A$tablename to B$tablename). So exploring if there is any alternative approach. Hoping for your reply.

    Many thanks!!

  • In that case, can you not just change the datasource (unless you have the database hardcoded)?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply