cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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_member183334
Active Participant
0 Kudos

Hi, Sreedhar,

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

Thanks

Sathya

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

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

Regards

Sreedhar

hedaoo_kalyani
Explorer
0 Kudos

Hi Sreedhar, How you solved the problem I am facing same issue, Please see attached screen shot for my Synonym.

Answers (0)