Issue with Pega Reporting DB setup
My client planning to setting up Reporting DB , and after updating the settings we observed below issue:
Reports consisting of DB joins with another report (in a different schema) are not working as expected after switching to reporting DB . Eg.. Report 1 table PGADATA.xyz Report 2 table PGARules.abc. After changing to Reporting DB as preferred DB , the report is throwing an error saying the table doesn't exist .The system is trying to query PEGAData.abc table and failing because this table belongs to PGARules schema.