I need to get a list of all reports that are scheduled out of business objects. How does one go about that?
jennifer.troyer (BOB member since 2016-05-17)
I need to get a list of all reports that are scheduled out of business objects. How does one go about that?
jennifer.troyer (BOB member since 2016-05-17)
[Moderator Note: Moving to Server Administration - MichaelWelter]
Welcome to B:bob:B!
Are you familiar with Query Builder? You can use it to query the system database.
I believe this will get all instances:
select SI_NAME, SI_KIND from CI_INFOOBJECTS where SI_INSTANCE=1
MichaelWelter (BOB member since 2002-08-08)
Unfortunately I do not even know what query builder is. I have very basic knowledge with Business objects and am just learning.
jennifer.troyer (BOB member since 2016-05-17)
OK, no worries. What version are you using?
MichaelWelter (BOB member since 2002-08-08)
SAP Business Objects Desktop XI
jennifer.troyer (BOB member since 2016-05-17)
Query builder should be available at http:///AdminTools/querybuilder/ie.jsp
would be replaced by your BusinessObjects Server.
MichaelWelter (BOB member since 2002-08-08)
THANK YOU!!!
jennifer.troyer (BOB member since 2016-05-17)
Is there a way to also pull destination and frequency? Thanks in advance.
jennifer.troyer (BOB member since 2016-05-17)
You will have to check the sub-properties of the query provided.
ambarishkunte (BOB member since 2018-11-19)
Is there a way to do this through an ODBC connection to, say, Microsoft Access?
I’m on BI4 4.1 SP7, in the process of migrating to 4.2, and it would be super-helpful to create a checklist.
While I’m at it, has anyone ever done this and also brought over folders, universes, and/or user security details?
Crazy_About_BO (BOB member since 2015-01-20)
Hi,
You may find useful Excel macros under BOBJ Downloads section.
SuKA (BOB member since 2018-10-20)
Wow, that’s an incredible resource!
Thank you!
Crazy_About_BO (BOB member since 2015-01-20)
Since posting this question, I learned about the the new CMS data access driver, introduced in BI4 4.2 SP3, to accomplish the same thing using a universe and Web Intelligence to query the metadata:
This article was published September 2019.
It doesn’t help me for 4.1, but hey…
Crazy_About_BO (BOB member since 2015-01-20)