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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (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 Previous  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
rhinok
Senior Member
Senior Member



Joined: 15 Jul 2008

Posts: 32
Location: Have AMEX, will travel...


flag
PostPosted: Mon Dec 21, 2015 2:59 pm 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

bobnoob wrote:
Hello everybody,

Using SAP Repository Documentor 9.0 , BO 4.1 SP6, Office 2010

Auth mode = winAD

Still getting CrystalEnterprise14.FW_InfoObject.1 - - 2147210694: 1000440

Can somebody help me out ? Which libraries have to be disabled ?

A working file would be the greatest!!!

Many thx in advance!!


I, too, get this error on a Windows 7 machine running Office 2013 against BI 4.1 SP7

On a Windows 10 machine running both Office 2007 and Office 2013 against the same BI 4.1 SP7 server, it runs perfectly (in either version of Excel).
Back to top
jian.qin
Forum Member
Forum Member



Joined: 02 Mar 2016

Posts: 6



PostPosted: Wed Mar 02, 2016 1:31 pm 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

First of all, thanks for providing such nice tool, which really helps.

I'm able to run the report successfully on XI4.1 SP7 with Excel2010. But not everytime, sometimes only universes data got collected while no documents data, which is pretty confusing.

And, I got the following error message on our production server, which is XI4.0 SP7 for each run, and it only collects universes information eventually.

CrystalEnterprise14.FW_Properties.1 -- 2147210697: Item2 was not found in the collection.1000440.

We turn off Crystal report services, only need Webi.

Any clue? Thanks very much!
Back to top
jian.qin
Forum Member
Forum Member



Joined: 02 Mar 2016

Posts: 6



PostPosted: Wed Mar 02, 2016 2:09 pm 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

OK, I find some clue. Seems if I don't specify the time range in the configuration panel, it will include the documents data collection.

Again, this is a super tool!

jian.qin wrote:
First of all, thanks for providing such nice tool, which really helps.

I'm able to run the report successfully on XI4.1 SP7 with Excel2010. But not everytime, sometimes only universes data got collected while no documents data, which is pretty confusing.

And, I got the following error message on our production server, which is XI4.0 SP7 for each run, and it only collects universes information eventually.

CrystalEnterprise14.FW_Properties.1 -- 2147210697: Item2 was not found in the collection.1000440.

We turn off Crystal report services, only need Webi.

Any clue? Thanks very much!
Back to top
Jegades
Forum Member
Forum Member



Joined: 23 Aug 2005

Posts: 2
Location: Virginia



PostPosted: Fri Apr 01, 2016 10:30 am 
Post subject: Re: SAP BI Repository Documentor

HI Fredie,
I had the same problem I am running Excel 2013 on my machine, but overcame by modifying the code in Modules. To do this go to view code mode and extend Modules folder, Right click BO Module > view code and replaced all 3 codes which states "kernal32 " to "kernel64", It started to populate all the document information.

Regards
Jega icon_smile.gif
Back to top
Seagrass
Senior Member
Senior Member



Joined: 18 Nov 2014

Posts: 32



PostPosted: Thu Jun 02, 2016 1:21 pm 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

I'm on 4.1 SP5 with Office Professional Plus 2010.

I am able to use this as long as I don't try to use the date fields in the configuration. Any values in there, and no results return.

I have an enormous BOE system, so this limitation is a bit of a problem. If a parameter for Top Level Folder were available, that would help.

Still a huge Thanks to the developer. (and my sys-admin for temporarily giving me God rights in production.... )

-S
Back to top
anastasia.isaev
Forum Member
Forum Member



Joined: 12 Jul 2016

Posts: 1



PostPosted: Tue Jul 12, 2016 2:21 pm 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Hi all,

Did anyone encountered that the excel returns data on the universes tab, but not on the documents tab?

I've ran it on 2 different machines, on the first one it works fine, on the second it works only for universes...

What could be the problem?
There're no errors, the ODBC seems to be ok (related?), the references in the VBA are just the same as on the first machine... Just null data returned.

BO 4.1, SP5 Patch 5. One server.

Will be grateful for any advice.

Thank you,
Anastasia
Back to top
Claire Everitt
Senior Member
Senior Member



Joined: 03 Sep 2002

Posts: 36
Location: Sussex


flag
PostPosted: Thu Aug 18, 2016 3:47 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Hi,

Can someone tell me what the begin/end date is for on the Document tab?

Thanks
Claire
Back to top
spmp007@me.com
Forum Member
Forum Member



Joined: 21 Sep 2016

Posts: 13



PostPosted: Wed Sep 21, 2016 4:11 am 
Post subject: Re: SAP BI Repository Documentor

I have been using this for a few years but recently (earlier this year) it stopped working. I have downloaded it again but it still isn't working so clearly something on my machine!

It stops on Dim SessionManager, Sess as SessionMgr and says compile error cant find project or library. I believe it may be a DLL for SessionManager - but I do not know what its called so I can see if its actually missing.

Can anyone give me a pointer please where I should look??
Back to top
karen
Principal Member
Principal Member



Joined: 18 Jun 2003

Posts: 397



PostPosted: Wed Mar 29, 2017 9:39 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Hello,
I have been using this SDK for a while and it has been very helpful.I'm trying to run "SAP BI Repository Documentor - SAP BI BusObj 4" ,it runs for a while pulling some data and errors out.Any idea on how to resolve this error.


VBAProject - 1004 : Application -defined or object defined error 1000095
Back to top
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 598
Location: USA



PostPosted: Tue Apr 18, 2017 1:56 pm 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Hi Sushir Patel
Great tool. Everything is working as expected in both 3.1 and 4.x
But macro is processing only for about 100K objects(records) and displaying 65K records only. Is there anyway we can make it unlimited? As you know that there is no restriction in MS Excel 2010.
Back to top
Sushir Patel
Principal Member
Principal Member



Joined: 19 Apr 2006

Posts: 132
Location: London


flag
PostPosted: Fri Apr 21, 2017 4:12 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Philip,

Save the SAP BI Repository Documentor.xls as a macro enabled document (xlsm) and try that. xls's are restricted to 64k rows.

Sushir
Back to top
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 598
Location: USA



PostPosted: Fri Apr 21, 2017 9:26 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Hi Sushir,
Thank you so much for your reply. I did but it is displaying around 100K rows only. As you know that when data is processing, once you hit the Extract Data button, the processing a small window is showing max rows count 109688 even though I have entered my limit 250,000 rows in selection criteria box. How to make it unlimited...?
Back to top
fta
Senior Member
Senior Member



Joined: 16 Nov 2006

Posts: 64


flag
PostPosted: Thu May 11, 2017 6:54 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Still works on BI 4.2 SP2 icon_smile.gif

There 1 minor bug I think
In function Function getRepUniDetails() you have:
...
InStr(1, "'Reports','Webi','FullClient'", DocRng(i, 5)) > 0

Should be:
InStr(1, "'Reports','Webi','FullClient'", DocRng(i, 6)) > 0


I also need to remove the error handling to make it work. Based on the details that I saw, I had an error due to firewall restrictions. Message in Infostore like described here: https://archive.sap.com/discussions/thread/3342398
Back to top
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 598
Location: USA



PostPosted: Thu May 11, 2017 1:56 pm 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Hi fta.
I have updated Function getRepUniDetails() code as below but still it is not working.
Old:
InStr(1, "'Reports','Webi','FullClient'", DocRng(i, 5)) > 0

New:
InStr(1, "'Reports','Webi','FullClient'", DocRng(i, 6)) > 0

I have entered 250000 number in Document Record Count cell in Selection Criteria box but processing document number is showing 96417 in process bar.
My question is why it is not showing 250000?
Back to top
fta
Senior Member
Senior Member



Joined: 16 Nov 2006

Posts: 64


flag
PostPosted: Fri May 12, 2017 4:44 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Hi,

For this you need to now queries on the repository are working. See https://wiki.scn.sap.com/wiki/display/BOBJ/Query+Builder

When I select all the options, this is the query that is generated:

https://drive.google.com/file/d/0B_Jp5knwmWsLMG16TXNjQnl1WGs/view?usp=sharing

Having said this, since SP3 you might have an other option:

https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+BI+4.2+SP3

Foad
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 4 of 6 All times are GMT - 5 Hours
Goto page Previous  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.0498 seconds using 17 queries. (SQL 0.0220 Parse 0.0010 Other 0.0268)
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