BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

SAP BI Repository Documentor - SAP BI BusObj 4
3 members found this topic helpful
Goto page 1, 2, 3, 4, 5, 6  Next
 
Search this topic... | Search BOB's Downloads... | Search Box
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Author Message
Sushir Patel
Principal Member
Principal Member



Joined: 19 Apr 2006

Posts: 132
Location: London


flag
PostPosted: Fri Dec 07, 2012 2:00 am 
Post subject: SAP BI Repository Documentor - SAP BI BusObj 4

The attached spreadsheet for SAP BI (BO 4) will retrieve information about the object (Reports, Universes, Connections, Categories, QaaWS and disk usage) in the SAP BI environment.

It will also provide information as to which reports use a specific universe and which reports may be affected by a universe change too - as returned when querying via the query builder.

It should be ran under the administrator account for the best results, but also works for delegated administrators/users.

The first tab has a section on the supported types and usage guide. It also mentions some limitations so PLEASE READ this first.

This utility should be ran on a workstation which has the full SAP BI client installation as it requires access to the libraries provided by the install.

If you are looking for the versions for XI R2 or XI R3 then please search for BOXI Repository Documentor.

PLEASE TEST ON A DEV ENVIRONMENT PRIOR TO USE ON PRODUCTION.

N.B Developed using Excel 2010 & SAP BI 4 SP4



SAP BI Repository Documentor.zip
 Description:
SAP BI Repository Documentor v9.0

Download
 Filename:  SAP BI Repository Documentor.zip
 Filesize:  423.84 KB
 Downloaded:  15422 Time(s)

Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19318
Location: Bratislava


flag
PostPosted: Fri Dec 07, 2012 9:08 am 
Post subject: Re: SAP BI Repository Documentor

Moderator note:
Approved, and moved to BOB's Downloads.



And thanks for sharing. thumbsup.gif
Back to top
BusObjGuy2
Senior Member
Senior Member



Joined: 27 May 2005

Posts: 41
Location: Kansas City


flag
PostPosted: Mon Dec 10, 2012 12:48 pm 
Post subject: Re: SAP BI Repository Documentor

Hi Sushir,

Thanks for the uploading the code. What are the DLL files needed for running this code in BI 4? Where can I download them from?

Thanks
jai
Back to top
Fernand_DaCien
Senior Member
Senior Member



Joined: 05 May 2006

Posts: 34
Location: Los Angeles, California


flag
PostPosted: Wed Jan 02, 2013 6:27 pm 
Post subject: Re: SAP BI Repository Documentor

Hello Sushir,

Happy New Year!
Thanks for sharing the script. I was able to run the script using the BI4 client assemblies, without any error.
It extracted the information for Universe, Connections, and QAAWS. But it didn't return any data for the Document, Categories, and UsageBy User.

Any ideas why?

Thanks,
ferdie
Back to top
scagliaf
Forum Member
Forum Member



Joined: 18 Apr 2012

Posts: 6



PostPosted: Thu Jan 03, 2013 10:39 am 
Post subject: Re: SAP BI Repository Documentor

Hi Sushir,

Finally something to extract info from SAP BI 4 repository!

Great stuff!!! thumbsup.gif

Cheers,
scagliaf
Back to top
Anna
Forum Member
Forum Member



Joined: 12 May 2005
ASUG Icon
Posts: 28
Location: Texas, USA


flag
PostPosted: Thu Jan 31, 2013 11:19 am 
Post subject: Re: SAP BI Repository Documentor for BI 4

Hi Sushir,

Thanks a lot for uploading the latest documentor. We are now upgrading to BI 4 Sp5 and I am hoping this file should still be able to pull.

I noticed that the 'username' column was missing under 'Connections' tab and this is a very useful information when trying to find out which connections are using what specific userids. We use 'Generic' userids and not personal userids and we want to know which connection uses what userid. This used to be available in ver 8 and now it is missing in ver 9. Is there anyway to make it available again?

Thanks again,
Anna

_________________
Thanks and regards
Anna

Business Objects Versions 4.5,6,6.5, XI R1,R2, 3.2
Oracle, SQL Server, Teradata, SAP BW.
Back to top
adityatanak
Forum Member
Forum Member



Joined: 20 Apr 2011
ASUG Icon
Posts: 2


flag
PostPosted: Thu Mar 21, 2013 1:10 am 
Post subject: Re: SAP BI Repository Documentor

Dear Shushir,

This Macro works like a charm.

But I am facing one problem.

I have just migrated my reports from BO 3.1 to BO 4.0.
Initaially all the Flash files were migrated and it had the type as "Flash"

After using "Dashboard ie Xelsius 2011" when we export it, the type changes from "Flash" to "Dashboards"

This "Dashboards" type is not being captured in your Macro.
Need to get documents with type "Dashboards" too.
Plz Help.
Back to top
J0sh
Forum Associate
Forum Associate



Joined: 08 Oct 2006
ASUG Icon
Posts: 638


flag
PostPosted: Thu May 16, 2013 11:47 pm 
Post subject: Re: SAP BI Repository Documentor

Would it be possible to get OLAP or BICS connections added to the tool under connections?

We use BW as our data warehouse and connect using BICS which doesn't appear under connections...
Back to top
harshiljoshi.sap
Principal Member
Principal Member



Joined: 11 Aug 2011
ASUG Icon
Posts: 248
Location: BI BO World


flag
PostPosted: Fri May 31, 2013 3:30 am 
Post subject: Re: SAP BI Repository Documentor

I received an error:

"Failure in btnExtData_Click()"

Crystal Enterprise12.SessionMgr.1--2147210751:1000440


icon_question.gif
Back to top
SandiR
Principal Member
Principal Member



Joined: 20 Dec 2004
ASUG Icon
Posts: 273
Location: By the sea


flag
PostPosted: Fri Jun 07, 2013 3:03 am 
Post subject: Re: SAP BI Repository Documentor

Hiya Sush
How are you doing?

...I had asked a question but then realised you had catered for it anyway (as I should have known icon_lol.gif ) but I wasn't able to delete the post

Cheers
Sandi

_________________
Sandi

Available for contract work throughout the UK from 1st September 17
uk.linkedin.com/pub/sandi-rocca/1b/262/776/

BI4 - Windows/Tomcat/SQL Server 2008
XI 3.1 - Solaris/Netezza
XIR2, 6, 5.1.9 - Solaris/Weblogic/Oracle

WebI, CMC, Xcelcius/Dashboards4, BI Mobile, CR, BI Explorer, DeskI
Back to top
snooms
Forum Member
Forum Member



Joined: 12 Sep 2011

Posts: 17


flag
PostPosted: Thu Jul 11, 2013 2:34 am 
Post subject: Re: SAP BI Repository Documentor

Hi,

This always comes in handy icon_smile.gif

But I was wondering if there is also a universe available with information about the reports, users, rights, instances, ...
I've had one for XI3.1, but it's not working for BI4.0 offcourse.
Or can we create one ourselfes maybe ?
Does anyone can provide me with info about this?

Thanks,
Mike
Back to top
david4nys
Forum Member
Forum Member



Joined: 22 Jul 2013

Posts: 1



PostPosted: Mon Jul 22, 2013 3:58 am 
Post subject: Re: SAP BI Repository Documentor

Hi Shushir,
Very Informative Upload. Thanks for your upload
Back to top
fel
Principal Member
Principal Member



Joined: 21 Oct 2008

Posts: 108



PostPosted: Thu Aug 22, 2013 8:30 am 
Post subject: Re: SAP BI Repository Documentor

Hello,

if I try to extract data from my 4.0 repository, I always get after some time the error

CrystalEnterprise14. FW_InfoObject.1 - 2147210694: 1000440

(sorry can't attach the screenshot, my attachement quota is exceeded)

This error appears after extracting of metadata for 200-300 WebI, so generally the code works.
How I can resolve this problem?
Back to top
mafta
Forum Member
Forum Member



Joined: 18 May 2011

Posts: 4



PostPosted: Tue Sep 17, 2013 11:00 am 
Post subject: Re: SAP BI Repository Documentor

Hi Sushir,

I am facing the same issue as fel above.
Could you please let us know if there is any solution for that?

Regards
Back to top
JonnySpec
Principal Member
Principal Member



Joined: 01 Aug 2008
ASUG Icon
Posts: 138
Location: Tampa,fl USA


flag
PostPosted: Thu Sep 26, 2013 12:27 pm 
Post subject: Re: SAP BI Repository Documentor

Getting an interesting error when the documents are being processed .

Error message:
CrystalEnterprise14.FW_Properties.1 --2147210697: Item 2 was not found in collection. 1000440


If I click OK the code continues to run . none of the documents info is captured but the universe information is. Oh the error does not occur until the # of # for the documents reaches the same ( all documents count) value

Environment:

Windows 2008 r2
BOE 4.0 sp6 fp3

Any ideas icon_question.gif crazy.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 6 All times are GMT - 5 Hours
Goto page 1, 2, 3, 4, 5, 6  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0349 seconds using 20 queries. (SQL 0.0062 Parse 0.0024 Other 0.0262)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo