Database Synonyms

[system]

Hi,

I have been asked to create reports on Synonyms rather than usual Tables. I am on BO XIR2. I haven’t worked much upon Synonyms.

Does BO Webi support Synonyms properly and are there any performance issues? I read somewhere about private and public synonyms and that BO supports one and not the other but I am not sure

---

Smith85 (BOB member since 2009-12-10)

[system]

You would be absolutely fine.

As long as the universe has got access to the schema/databases and thus the synonyms, you would be able to create reports on them.

Cheers.

---

BO_Stuffed (BOB member since 2008-03-29)

[system]

Oh thanks BO_Stuffed I am relieved. That means I just need the access to them and then it works similar to tables.

---

Smith85 (BOB member since 2009-12-10)

[system]

---

BO_Stuffed (BOB member since 2008-03-29)

[system]

Hi,

This older topics discusses usage of synonyms. Worth of reading:

120×120 10.4 KB

Hi ALL, This is very crucial for us as we are implementing new DB .Our universe is set on old DB (say ABC) now they have new DB (Say XYZ) there are couple of tables that will be available in New DB (Deleted in old DB) they created synonums for those in old ABC and asking us to access from there. My Question : I know linking tables accross DB ,but Can I access the new tables (from new DB XYZ) in my existing universe(which is on ABC, DB). They need an answer ASAP.Please help me.Thanks. madhu…

---

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

[system]

So, in case I am not able to view data, I will need to create dervied tables. Also, those Synonyms are pointing towards Views (and not tables).

Won’t this be an overhead or may be lead to performance issues?

I thought it would be better If I had access to Views (which I don’t)

Edit: I just read more about it. May be, its too enforce some kind of security.

---

Smith85 (BOB member since 2009-12-10)