Skip to Content
avatar image
Former Member

How to re-mapping schema?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 30, 2016 at 07:00 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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