Accessing Oracle Views or Synonyms in Universe

[TomDavies]

We are building a Universe on an Oracle database and wish to include a a table in another Oracle database.
If we were to do this in SQL we would:
- create a database link
- create a synonym for the table
- query against the synonym as if it were a table

We are however unable to pick the synonym from the table browser in Designer.

So we tried a view instead, but Designer is not seeing our view either!

Can BO only select from tables?!
Do we need to enable an option to allow us to "see" views and synonyms as well as tables?

This must be possible without having to create a local copy of the table!

Thanks in advance for any help!

 

[ATP]

I have done this by creating a view and then a synonymn for the view and it works fine.

The only time I've ever had problems with not seeing tables is when using a Microsoft ODBC driver to link to an Oracle database (God knows WHY I would try something so Daft!!).

Only thing I can suggest is to check the following :

1) Have you pressed the REFRESH button on the table list in designer?
2) Can you see the view in SQL when you log on as the user used by Business Objects?
3) Create a public synonym

Hope this is of some help.

4) Check the Grants against the user

 

[TomDavies]

Thanks for your help ATP.
We are still unable to use a synonym/database link combination, but having changed the privs of the user we are able to use a view based on the database link.
Thanks again!

 

[mili]

Hi ATP,
I have a typical problem. We have created a view of the tables from siebel, also have a universe exisiting , but the information present in the view doesn't exsist in the universe, can we link these two, is it possible to access information outside the universe.

Thank you in advance.

 

[jimbopalmer]

Actually in a fit of paranoia, made a Oracle use BO, and granted select on all tables to BO, with synonyms, so that even in free hand SQL, my users cannot write via Business Objects. The one thing you can't give for your heart's desire is your heart. - Lois McMaster Bujold

 

[ATP]

mili,

As long as the creator of the view has access to the underlying tables you should be OK by granting SELECT to the BO user on the view.

 

[wordoftheday]

other option is looking at / modifying the 'stora7en.txt' file on your local machine as this contains the scripts BO uses when getting the list of potential candidate tables..