Public Synonym

building semantic layer
1

Dear All,

I have checked old post for selecting public synonym by setting the attribute “OWNER” to ‘N’ in prm file.

Inside the folder (BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\oracle)

When I do it, the select table function in designer becomes weird that all objects are not grouped by schema

I want to have public synonym, but do not want to affect my normal development process. One approach for me is to create a derived table that select all from the public synonym. Is there any better way to do that? Are there any better method in latest version of BO?

Thanks

summoner :hong_kong: (BOB member since 2008-12-18)