BusinessObjects Board

Listing/printing universe joins

building semantic layer
#1

Does anyone know of a way to list all universe joins in a way that I could copy and paste them into a word document?

Thanks. 8)

sklimke (BOB member since 2005-07-28)

#2

Moving this topic from the General Discussion forum to the Semantic Layer forum.

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

#3

You might find this utility useful.

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

#4

You might want to try a BO report on top og the ManagerO universe (Joins class). You are going to get Join ID, Join SQL, and Table1 & Table2. If you are using Oracle, you can use it with minimal changes. If not, you do not need to convert everything, just these few object to the proper db syntax, if needed. Please note that the ManagerO is not 100% full proof. If you do not get the right results (no data to fetch, for example), double check the universe joins around the JOINS table.

MarcoR :us: (BOB member since 2006-03-29)

#5

I tries the utilities sent by Dwayne.

But i try to do smae, it says Macros in this project are disabled …

Please suggest how it works

Thanks

BOLearner (BOB member since 2005-01-20)

#6

Hmmm … I would suspect a security setting on your Excel installation. There is nothing disabled on the xls files themselves.

BOB users are not shy, and after nearly 600 downloads, I’m sure I’d have heard about it by now :yesnod: .

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