BusinessObjects Board

List of reports and respective universes

What is the Query Builder SQL to get all reports and their associated universes? Thanks. (BOE 4.2 SP3)


frank35 :uk: (BOB member since 2005-08-25)

Don’t do it like this.

See if the repository documentor can help (SAP BI Repository Documentor - SAP BI BusObj 4)


Damocles :uk: (BOB member since 2006-10-05)

Looks good but I need to do it without downloading software onto company systems!


frank35 :uk: (BOB member since 2005-08-25)

It’s excel.

Surely you have excel?


Damocles :uk: (BOB member since 2006-10-05)

Ok. I have it open now. How do I specify which environment to extract from?


frank35 :uk: (BOB member since 2005-08-25)

No auditor installed?

The activity universe can be used for this.

It has to be noted it only “works” if the report has actually been run.


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

BI4.2 SP03 includes a new data access driver for performing CMS queries via WebI.

Joe


joepeters :us: (BOB member since 2002-08-29)

Oh…very nice.

Thanks for sharing Joe :smiley:


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

Does running the Repository Documentor download take up space on the BO Server? (log files etc).


frank35 :uk: (BOB member since 2005-08-25)