system
April 7, 2009, 11:43am
#1
Scnerio:
I have nearly 20 folders & sub folders inside the public folder.
Issue:
I want to create a document, that is having all the details of public folder in webi to excel or pdf or word.
any option is to import all the information automatically?
Please suggest me to get those information from BO WEBI Application.
Thanks.
Radha
radhu (BOB member since 2009-02-12)
system
April 7, 2009, 11:49am
#2
What you mean by any information
Are you looking for a list of reports in a specific folder
Do a search using keywords ‘query builder’ or ‘CMS SDK’
.
haider (BOB member since 2005-07-18)
system
April 7, 2009, 11:57am
#3
I’m not looking for single report.
I want to have all the list of reports information in Public folder as excel or kind of document.
like below
i have 300 reports on my public folder. now i want the name of all the reports and their coresponding folder name.
Is any way to import the name of all 300 reports to any doc?
radhu (BOB member since 2009-02-12)
system
April 7, 2009, 12:04pm
#4
A look into the downloads section of BOB would help
Found one post here
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 …
.
haider (BOB member since 2005-07-18)