Table Usage in Reports

building reports webintelligence
1

Hi All,

How can I find the list of tables used for BO WEBI Reports?
I have around 100 Reports I need to find out the table usage for these reports.

Warm Regards

SivakumarS :singapore: (BOB member since 2006-08-10)

2

Hi,

I think you need to clarify what you’re asking for us a little. Do you mean type of table - horizontal, vertical, crosstab and form being the answer or do you mean something else?

Regards,

Steve D

SteveD :uk: (BOB member since 2009-11-02)

3

I want to know what are the DataBase Tables used for the list of reports.
BOXI V3 WebI Reports.

SivakumarS :singapore: (BOB member since 2006-08-10)

4

In that case you need to either check your reports and the objects they’re returning and querying versus the universe(s) yourself or start consulting with your universe admin. There’s no way to get webi to return the table names that data is drawn from.

SteveD :uk: (BOB member since 2009-11-02)

5

You could try here, to capture the objects, universes. unsure about the SQL.
You may then be able to use the universe documenter, in conjunction with your results, from this, to ascertain the table useage.

https://bobj-board.org/t/80856

Mak 1 :uk: (BOB member since 2005-01-06)