Hi Experts,
I have changed the connection in data foundation layer.However, the business layer is not pointing to the new connection.
Explanation:
Initially, the connection was pointing to the Dev system(NonSAP system) for the testing purpose, I have changed the connection to point the Production system.
The table names remain same however the libraries are different.
I have manually changed the Owner to production library in the Data foundation(Right click on table->change Qualifier/Owner). I have done the same for all 20 tables in DF and saved it.
However, the objects/fields in the business layer are still pointing the development system's library.
ie, field1=dev_library.table_name.field1
I manually edited the SQL to field1=prod_library.table_name.field1.
Which works fine and the object shows the production data.
It is very tedious to do this manually for all fields/objects in each of the 20 tables.
Could you please let me know how to automatically refresh the business layer so it points the new production connection by itself.