Importing Synonyms does not import Column Names in Designer

building semantic layer
1

Hi,

I have 2 schemas. 1 where the tables reside ( X_PRJ ) and another schema (X_SH_PRJ) which has Synonyms to the tables in X_PRJ schema. This is as per the conventions provided by the customer and we do not have authority to consider altering this logic to use Views or Tables instead of Synonyms.

I need to import these Synonyms and use these to Create my Universe.
But when I go to Import -> Tables, I cannot view the columns in the Synonyms. Even after importing, the columns dont show in the Universe.
Only the Synonym Name got imported.

Would be very thankful for any solutions/pointers to this problem.

Thanks!

Best Regards,
Pooja

Pooja.29.84 (BOB member since 2010-04-28)

2

For some Reason on retrying it is showing columns as well. But then on another try it is not. :crazy:

Pooja.29.84 (BOB member since 2010-04-28)

3

Pooja, welcome to B:bob:B!

Jansi :india: (BOB member since 2008-05-12)

4

Hi Pooja,

Are these synonyms private or public? Are they available for the user that is used in the universe connection?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

try to look your table on toad/sql +/… with the user used for BO universe connexion.

I think you have a bad script to create your synonyms

charlys2112 :fr: (BOB member since 2005-10-28)

6

Hi Jansi, Thanks!

Hi Marek, These synonyms are Private and are created in the same schema used by the Designer to login to the database.

Hi Charlys, The Synonyms are fine and have no errors.

The problem was intermittent as you can see in the file attached. Maybe a BO Bug or a network/connection issue? Not sure…
Screenshot.doc (34.0 KB)

Pooja.29.84 (BOB member since 2010-04-28)

7

For your 4 views in error. Are you sure you have grant select on it ?

charlys2112 :fr: (BOB member since 2005-10-28)

8

Charlys, Since I have myself created these Synonyms and granted access I am sure there is no issue with grants. I am now able to import all the tables. It was an intermittent problem which solved automatically. Thanks for all your efforts!

Pooja.29.84 (BOB member since 2010-04-28)

9

Hi Pooja,
Did you get an answer for this, I have the same problem…

Please let me know if you have any answer…

Thanks a lot.

madhu@P (BOB member since 2008-08-04)