system
May 20, 2009, 11:51pm
#1
Are there ways to pull a list of all the report names and descriptions in the BO XI R2 system? I used Query Builder to do it, are there any other ways? Thanks!
vanessa (BOB member since 2009-01-20)
system
May 21, 2009, 4:11am
#2
Hi,
Have a look at this utility:
Author: Jim McGregor, james.mcgregor@zionsbancorp.com
Author notes:
Platform: Microsoft Excel 2003 / XIR2 SP4
Version: 1.0 (See version 1.1 here )
Code:
Rather than post the code verbatim, here is an overview of the logic:
1. Connect to the CMS (Thanks Julien!)
2. First Loop - Loop through the three types of reports: Crystal, Webi, Deski
2. Second Loop - Extract the list of reports.
3. Third Loop - Count up the number of instances and calculate the avg runtime.
Retrieve Report Statistics …
You may find it useful.
Marek Chladny (BOB member since 2003-11-27)
system
May 21, 2009, 2:29pm
#3
Yeah, it is definitely useful. But it doesn’t have report descriptions. Are there any other macros that include report description? Thanks!
vanessa (BOB member since 2009-01-20)
(BOB member since 2003-11-27)