How to change the Database connection in the existing FRS report

Boobalan_A

Hi Team,

While migrating the report to test to Dev1 we are facing problem.

Note: We created a report in the Test instance using the GG Database connection. Now the problem is that the report is not working while being migrated to Dev1 instance. Because the Dev1 database connection differs from the TEST instance.

Kindly assist us to change the Database connection in the existing FRS report.

Regards,

Amsa R

Subha_Tripathy-Oracle

Hi @Boobalan_A

Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page.

Following a successful import of .dva file, check that your imported connections are valid by opening and saving them.

Please refer "Edit a Data Source Connection" in the below document.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/manage-connections-data-sources.html#GUID-7ACF8B89-3285-4922-AE12-64D04B7171EF

Thanks

Subha

Renuka Nuguru-Oracle

Hello,

If this question is related to the Financial Reporting for Oracle Enterprise Performance Management Cloud, Changing the Database Connection. Please refer to the below given EPM document.

https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/frafu/change_database_connection.html#fr_book_838

Things to consider while changing the DB connection in FRS

When the dimensions in the changed database connections do not match the previous dimensions, an error message similar to the following is displayed:

1012:Report contains an invalid grid. The following dimensions could not be found: <Dimension>

Refer to the below given video too

https://www.youtube.com/watch?v=ajNY00BE8RE

Thanks,

Renuka