XIR2 - Retrieve Report Statistics Macro

system · February 26, 2009, 10:37pm

Thank you very much for this tool Alpha.

BNReddy (BOB member since 2006-06-27)

system · March 11, 2009, 8:51pm

Hi,

This is really a nice app. Thanks a lot.

Is there any limit set on the number of reports? When ever i try to run this report it only give me 2000 records (Report 1000 and WEBI 1000). If so can you please let me know how to change it. I have definitely more than 2000 in total.

Thanks

writetoprav (BOB member since 2007-04-09)

system · March 12, 2009, 2:11am

Thanks for the heads up on the “bug”. Most likely this is because queries run against the repository have natural limits on them (1000 records seems to be the most common limit). I’ll most likely have to change the select statements in the code to read something like:

SELECT TOP 10000 <something, something> from <tablename> where <conditions>

By adding the “TOP 10000” to queries against the BO SDK, it overrides the limits. I’ll try and get this fixed as soon as I can.

alpha1145 (BOB member since 2006-01-04)

system · March 12, 2009, 6:42pm

Hello,

Thanks a lot for quick response. Adding “TOP 10000” worked like a charm. Changed it myself and tested it as well.

Thanks

writetoprav (BOB member since 2007-04-09)

system · March 20, 2009, 7:07pm

Hi. This is a great tool. I have a question why I got ‘0’ values in the Number of Instances, Number of Recurring Instances, and Avg Runtime as ‘-’.

Do I need to enabling anything on my end to capture these statistics?

Thanks.

bstn82 (BOB member since 2008-06-27)

system · March 24, 2009, 3:59pm

This is an update to the Retrieve Report Statistics Macro. I added the “TOP 10000” to the select statements in the code to prevent the records from being limited to a 1000 records. I’ll update the original post after the file has been updated.
Retrieve Report Statistics Macro.zip (16.0 KB)

alpha1145 (BOB member since 2006-01-04)

system · March 25, 2009, 1:33pm

Make sure you add the “TOP 10000” to the select statements that are pulling the count of instances as well, otherwise it will cap that to 1000 records as well. I have a corrected version of the macro and I’m waiting for it to clear “BOB’s Uploads”.

alpha1145 (BOB member since 2006-01-04)

system · March 25, 2009, 1:34pm

Does the report in question have any scheduled instances? If not, then I would expect you to get a “0” value for the number of instances, number of recurring instances and Avg Runtime.

alpha1145 (BOB member since 2006-01-04)

system · March 25, 2009, 1:49pm

Just as an FYI, it takes me 67 minutes to run this macro and collect statistics on 8001 reports. So if you have a lot of reports, be patient.

alpha1145 (BOB member since 2006-01-04)

system · April 7, 2009, 11:42am

I am getting compile error: Can’t find project or library.

Vills (BOB member since 2007-10-24)

system · April 10, 2009, 7:47pm

Hi,

Is there a way to modify the code to have this tool work for BO XIR2 SP2.

Right now it error out as

CrystalEnterprise12.SessionMgr.1 - -2147024891: Access Denied. You cannot log on to an older version of the CMS. 1000440

Thanks,
Goutham.

gauthamvarma (BOB member since 2007-06-10)

system · April 13, 2009, 6:24am

Hi,

I want only WEBI list of reports from the public foler.
Is there any customised macro availble to get WEBI list of reports?

Many thanks in advance.

radhu (BOB member since 2009-02-12)

system · April 13, 2009, 7:04am

Hi all,

Can anyone help me, how to extract list of reports which is availble in WEBI public folders only?

I ran the script but its giving me lots of reports that couldn’t be understood.

I want to have list of reports in WEBI Public folder - any chance to get?

radhu (BOB member since 2009-02-12)

system · April 17, 2009, 9:47pm

Make sure that you are running it on a machine that has the BO client tools installed (Designer, Deski, etc). That will install the proper .dll libraries that the macro needs to run.

alpha1145 (BOB member since 2006-01-04)

system · May 4, 2009, 7:06pm

Make sure you have the XIR2 client tools (Deski, Designer) installed on the same PC where you are running the macro. The macro is dependent on code library files (.dll’s) that are installed with the Business Objects client tools.[/quote]

alpha1145 (BOB member since 2006-01-04)

system · May 14, 2009, 9:08am

Thanks for this, it’s saved me a lot of time!

rjp (BOB member since 2007-02-26)

system · May 14, 2009, 11:03pm

The update has been merged into this topic and is viewable here.

MichaelWelter (BOB member since 2002-08-08)

system · May 21, 2009, 3:20pm

I have both xir2 and r3 on my machine. I keep getting an error about access the older cms when I try to run this.

I have gone into the vba tools and tried turing on most of the 11.5 dll’s and I am still getting that error.

Any idea what I need to add /take out to have it run on xir2 and not xir3?

PatLong (BOB member since 2006-04-25)

system · June 9, 2009, 1:24pm

Hi,
I have reports with more then 5000 instances.It looks like this excel is only displaying count of 5000 instances.

For example --Efashion report has 5900 instances,but excel shows count of 5000.Is there a limit on count ,is there a way to tweak the code to display count of all instances.

karen (BOB member since 2003-06-18)

system · August 28, 2009, 12:34pm

Hello,

Is there a way to change the code to retrieve Crystal Reports Stats?

Thanks

Shifty (BOB member since 2005-09-29)