on 05-30-2016 6:22 PM
Hi,
We have some existing HANA calculation views which use tables in one schema. Now we need those views to point to tables in another schema with same table name. I know it can be done by opening the view and them replacing data source for each table. I am just wondering if there is an easy way to re-mapping it?
Thanks.
Scott
Hello Scott,
do you work already with an authoring schema? If yes, then it would be easy to change the schema mapping to a different physical schema + regeneration of views. Details can be found in the online help: Map Authoring Schema to the Physical Schema - SAP HANA Modeling Guide - SAP Library
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Florian,
I tried it with schema Mapping. But I got an error message ' Authoring schema already exists as a physical schema'.
I found a work around solution. I exported all views; then open the views and replace schema name with new name; then import the views back. Everything looks fine now.
Thanks again.
Scott
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.