Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Changing the Data model connection to point to different database and data not being reflected
Summary
Changing the Data model connection to point to different database and data not being reflectedContent
Hi all,
We are developing a use case in OAAC. Initially, we had a connection named "Test". In that, we had a database named "A" and made it point to the data model. Later on, we changed to database "B" in the connection "Test" (which has the same set of tables as the database "A") After this, the data in the reports is only referring to the old database "A" instead of pulling the data from the database "B".
For example:
A table named "ABC" has a record count of 81 in the database "A" while the same table has record count of 94 in database "B".