We have a requirment where we have different Implementation tables based on the Region in the Same Data Base Schema, all reports are created on the FrameWork Layer and using the Report on Decendent Classes which is working Fine.
But we have a new Requirment where we want to Report on Different Implementation tables and send out a consolidated Report across all the Regions(The data for different regions are stored in different Implementation Tables) in the PDF format to the Subscribed Parties on Monthly Basis.
Can you please let us know what would be the best Approach to implement the Above mentioned requirment or i mean how to do it in a Report?
As the Implementation Tables are in different Schema and we have an requirment to repot on all the Implementation Tables, which option would be better and more optimized from PRPC.
By working with a DBA and using a Master Slave or similar Technology to Extract the Data from Multiple Implemantation Tables to a Common Table in a Reporting DB Schema and then Report out of Common Table using the Repoort Definition by mapping the Table in PEGA.
To use BIX for the above mentioned requirment.
We thought of using the DB View but the Implementation Tables are in Different Schema it is tough to achieve the above requiremnt.