Skip to Content
avatar image
Former Member

HANA 2.0 SPS 2 , Synonym fields are not visible when added into a calculation view.

Hi

I have created a Synonym pointing to Classical Schema following the steps mentioned in the blogs and its successful, I am able to see the synonym in database explorer and also data is visible.

I have maintained the dependencies in the yaml file as well. Even though Synonym working when tested in DB Explore , I have the below issues

1. When trying to create the synonym using the editor I am not able to get the list of tables from classical schema ,even after selecting the user provided service. I was only able to create the synonym using the Text editor , but the synonym is working fine.

2.When I try to use the same synonym in a calculation view , not able to see the fields of the synonym.

Regards

Sreedhar

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Hi Guys,

    Can somebody help us on this issue couldn't find anything in the community forum on the above type issue.

    Regards

    Sreedhar

  • Former Member

    Hi, Sreedhar,

    Can you share sql code what you wrote for synonym function??

    Thanks

    Sathya

  • Former Member Former Member

    Hi Sathya,

    Thanks for your response, please find my code below.

    "TestHDI_Core.db.synonyms::customers": {
    "target": {
    "object": "CDS.Customers",
    "schema": "ClassicalSchema"
    }

    }

    I wrote this code in the code editor and my synonym is working fine in the DB explorer where I can see the data.

    Regards

    Sreedhar

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 27, 2017 at 06:27 AM

    Hi

    I was able to resolve the issue , actual the problem is with the user provided service.

    Regards

    Sreedhar

    Add comment
    10|10000 characters needed characters exceeded