BusinessObjects Board

How to get list of all tables used in a given universe

sdk development
#1

Friends,

How can i get list of tables used in a given universe ? I want to generate a txt file to have all the tables used by that universe.

thanks in advance

ThrownIntoBO (BOB member since 2007-08-22)

#2

Hi,

Have a look at this universe documenting utility in BOB’s Downloads section.

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

#3

Excellent !!!

thanks a lot!

ThrownIntoBO (BOB member since 2007-08-22)

#4

On the same note, is there a automated way to display sql query from agiven report ? whether its free hand sql or generated by BO.

Or list of tables (columns) used by report …

Any help would be greatly appreciated …
Thanks

ThrownIntoBO (BOB member since 2007-08-22)

#5

If you run this VBA procedure in the report

Sub ShowSQL()
  Dim myDPs As DataProviders
  Dim myDP As DataProvider
  
  Set myDPs = ActiveDocument.DataProviders
  
  For Each myDP In myDPs
    MsgBox myDP.SQL
  Next
End Sub

It will display the SQLs of all data providers. In SDK section of BOB you can find more examples of the same. Maybe also some example how to automate this process for more reports and/or how to log the SQLs into text file.

Have a look also at this utility.

[Moderator Note: I am moving this ropic to SDK]

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

#6

Hi,

Check this universe Documentor for XIR3.1 and 4.0 and the best thing is you can get the specific information about your all the universes on server in one click.

arnaeem (BOB member since 2013-02-03)

#7

Use ebiexperts vérsion manager it’s straightforward
You get table and columns used in a report

whairnud :belgium: (BOB member since 2006-04-28)