Skip to Content
0

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

Oct 25, 2017 at 09:32 AM

55

avatar image
Former Member

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

10 |10000 characters needed characters left 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

0
Former Member

Hi, Sreedhar,

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

Thanks

Sathya

0
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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

Hi

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

Regards

Sreedhar

Share
10 |10000 characters needed characters left characters exceeded