system
September 24, 2010, 5:28am
#1
Hi Exeprts.
Please help to prepare a report that contains all reports in business objects.
Thanks in advance…
ajeshgarimella (BOB member since 2009-06-06)
system
September 24, 2010, 10:44am
#2
Have a look in the downloads area, there is an Excel utility that will do this
Kev.
kev-martin (BOB member since 2008-08-14)
system
September 24, 2010, 1:27pm
#3
Hello -
The best way to create a true “report of reports” would be to surface the actual CMS metadata directly into a Web Intelligence report. The first of the following solutions can actually do this. All solutions below are free.
They are:
Infolytik’s free XI3 CMS Query and Reporting Universe driver
http://www.infolytik.com/cmsconnect-community-edition
BOXI Repository Documentor:
I have created the attached spreadsheet for XI R3 which will retrieve information about the reports, Universes, connections and categories in the BOXI environment. It will also provide information as to which reports use a specific universe and which reports may be affected by a universe change too - as returned when querying via the query builder.
It should be ran under the administrator account for the best results, but also works for delegated administrators/users.
The first tab has a secti…
List Repository Objects:
Author: Adrián BO_Worker developed from Julien Bras’ userlist utility.
Author notes: Excel 97-2003 VBA application. Displays some lists for users, groups, universes, reports… Only reading, not writing back. Please go to configuration sheet and fill Server, Username and Password in order to get it working. After that try the rest of sheets pressing the buttons to field the data below. Whenever you get orange cells that’s a place you should fill. If you get Id and Name to fill you can write one o…
Instances Viewer:
Author: Rachidb
Author notes: This macro generates information about instances finished/running/pending. It accepts a date range. If start date is omitted it shows instances statuses for a given day starting 12AM until time of run. End date is also option and will default to current date/time.
Rows returned is limited to 64000 rows. But please be careful not to run for a big date range as it may overload your CMS.
Platform: Excel 2003
Version: Initial release 1.0
Feel free to give feedback …
Hope this helps
Atul Chowdhury (BOB member since 2003-07-07)
(BOB member since 2008-08-14)