system
March 11, 2015, 12:50pm
#1
Hi,
I tried searching for a macro which can help me to get the scheduling details of all BO reports on BI 4.1 but couldn’t get, so thought to take some help if there is any macro available? Please guide me, that would really be great…
aniketp (BOB member since 2007-10-05)
system
March 13, 2015, 3:07am
#2
Could someone please help me here if there is anything on BI 4.1 which can get the scheduling details or any good Macro ? - Thanks in advance.
aniketp (BOB member since 2007-10-05)
system
March 15, 2015, 7:42am
#3
On checking BOB downloads, found some of the old posts
Author: Jim McGregor, james.mcgregor@zionsbancorp.com
Author notes:
I wrote this macro to be able to retrieve certain information about recurring instances, specifically event dependency and destination email addresses (if applicable to the schedule). This program is an Excel macro that will extract a list of all recurring instances in the repository and provide some stats about each : Name, update date, create date, parent report folder path, name of event dependency, destination email addre…
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 …
Author: Joe Peters (with thanks to Rachidb)
Platform: MS Excel
Version: 1.0
Notes:
xi3sched.xls (197.0 KB)
joepeters
haider (BOB member since 2005-07-18)
(BOB member since 2007-10-05)
(BOB member since 2005-07-18)