How can we use Synonyms as objects?

building reports desktopintelligence
1

Hi,

In my database we have Synonyms,i want use this Synonyms in my universe and creating reports.How can we use Synonymsin universes as objects.Any one help me

kumar123 (BOB member since 2007-08-19)

2

Hi,
Synonyms can be used on the same way you are using tables. Synonyms are nothing but the read only access of the tables.
You can just create the objects based on the synonyms.
Just make it sure that the database login you are going to used in designer is having that synonym access or not.

Omkar Paranjpe :us: (BOB member since 2006-02-13)

3

Be careful when using synonyms. One of the functions you will lose is the ability to do is browse the table as business objects is not able to display columns in a synonym.

jonathanstokes (BOB member since 2004-09-17)

4

Hmmm … not sure if it’s a database specific issue you are having, but we almost exclusively use synonyms and they “browse” just fine.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

5

If I’m remembering correctly, the synonyms should be “private” or they won’t show in the universe. Or was it “public”…

In any case, only one of both will work, sorry about the memory leak :roll_eyes:

Greetz

Andy

andy_v_belgium :belgium: (BOB member since 2008-03-04)

6

Thought I would post back to clarify things. I am using sql server 2005 and if you create a synonym you can definitely NOT see the columns in the table display in designer. The workaround is to create a view on the synonym if you want to view the columns.

There is no such thing as private and public synonyms in sql server. They are orcale based.

jonathanstokes (BOB member since 2004-09-17)