BusinessObjects Board

How to extract all the table names and joins

building semantic layer
#1

I want to extract all the table names and joins used.Is there anyway to do it?

dave11 (BOB member since 2008-08-30)

#2

Use the Print functionality to just get what you need. Print it to pdf then cut and paste from the pdf.

#3

There are two utilities in the BOB’s Downloads area that will extract universe information into XLS. Note: these will not work in BI 4.0 as the new Information Design Tool does not currently offer an SDK.

But for now, one of these should work:


Dave Rathbun :us: (BOB member since 2002-06-06)

#4

Thanks a lot dave,mark.i tried to use the utility.Got a error message saying the buffer is full.

dave11 (BOB member since 2008-08-30)

#5

Please post your issues with the utility you used in the respective topic, thanks.

Dave Rathbun :us: (BOB member since 2002-06-06)

#6

Hi,

For your purpose you can use Mark suggesstion of printing the universe as save as pdf.

Go to Tools --> Options --> Print/Pdf and select only tables, joins and deselect everything else.
Then Save as the universe and select pdf as filetype. this pdf generated will give you all table names and joins.

saurabhg :india: (BOB member since 2007-04-02)