In our organization we have BO running on Netezza database for few years now , now we are upgrading to Teradata . In this process we are planning to modify tables and columns due to adopt to new changes and merging with other line of business .
we have few thousands reports are already running on Netezza with existing database structure. Is their a way to update the reports using backend process to change the columns in reports rather than re designing the reports.
Any help is appreciated .
unfortunately, SAP doesn't provide a batch repointing utility .
this would have to be done in WebIntelligence on a per document basis, using the dataprovider "Change Source" workflow. (at which stage you reconfirm the object mappings between old and new.)
I believe there are also partner-provided solutions available for this kind of task which are externally available.
You need to elaborate on the exact requirement and scenario.
When you say "modify tables and columns due to adopt to new changes and merging with other line of business ."; are you adding or removing columns from the table?
If yes, the changes should first reflect in the universe. Once done, they will automatically reflect to the reports.
When you say "Is their a way to update the reports using backend process to change the columns in reports rather than re designing the reports." , what are the changes that you are expecting?
Follow this process:
1. Create exact replica of Netezza data model in Teradata.
2. Create new connection against Teradata and test it.
3. Set new connection for your universe to point to Teradata.
4. Do an integrity check and fix the errors.
5. Once done, save and export the universe.
6. Open associated Webi reports, refresh and check.
NOTE: Never "Save As" or "Copy" your universe to another name. This will change the CUID and will break the link with associated reports.