BusinessObjects Board

Macro to get objects and rows used in report?

Hi
How can I get all the objects and rows from my sql database from a report. I want to maintain a report to get universe change impacts on already created reports.

The result could be:
Name of report | object | class | table | row

Thanks.


fmolmy (BOB member since 2005-08-11)

Maybe https://bobj-board.org/t/16473 can help you. Or the SQL server repository universe at https://bobj-board.org/t/34413.


jobjoris :netherlands: (BOB member since 2004-06-30)

Take a look at this utility. It’s from one of my conference presentations last year, and I think does exactly what you are looking for.


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

Thanks, I used your utility that worked fine!


fmolmy (BOB member since 2005-08-11)