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: Upcoming Events: PGHBOUG: Oct 19.

SAP BI Repository Documentor - SAP BI BusObj 4
2 members found this topic helpful
Goto page Previous  1, 2, 3, 4, 5
 
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
veparala
Senior Member
Senior Member



Joined: 18 Feb 2008

Posts: 72



PostPosted: Tue Jun 20, 2017 10:11 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

I am getting the below error when i tried to run this excel

VBA Project - 1004: Application - defiled or object -defined error 1000095

Excel 2010
BI4.1 SP6

Anybody got this error and resolved it?

Thanks
Venkat
Back to top
pcgeekus
Principal Member
Principal Member



Joined: 16 Oct 2003

Posts: 195
Location: Moline, IL


flag
PostPosted: Mon Jul 24, 2017 3:55 pm 
Post subject: Re: SAP BI Repository Documentor

This no longer works in 4.2 SP4, not sure why. I do know SAP had major security changes in SP4 since this did work in 4.2 SP3 along with my other VBA apps. Any ideas on how to fix the Logon part? I get "Internal Error" banghead.gif
_________________
"Another day...another bug"
BO 4/5/XIR2 SP5.2, XI 3.1 SP3.5, Now on 4.1 SP5, upgrading to 4.2 SP4. 130K+ reports and 65K users.
Jon F.
Back to top
samdouglas77
Forum Member
Forum Member



Joined: 14 Sep 2011

Posts: 2
Location: New Zealand


flag
PostPosted: Sun Sep 10, 2017 6:57 pm 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

I got this working in 4.2 SP4 using Excel 2016.

I have the following References ticked: (may not need all though)

Visual Basic for applications
Microsoft Excel 16 Object Library
OLE Automation
Microsoft Office 16 Object Library
Microsoft Forms 2.0 Object Library
Business Objects Designer 14 Object Library
Crystal Enterprise Framework Library 14
Crystal Enterprise Infostore Library 14
Microsoft XML v6.0
Changing the following:

in Sub ConnectionDet():
change

Dim xml_doc As New DOMDocument
to
Dim xml_doc As New DOMDocument60

and make sure you save it as a .xlsm file so it keeps the vb code.
Back to top
HetalKataria
Forum Member
Forum Member



Joined: 17 Oct 2017

Posts: 2



PostPosted: Tue Oct 17, 2017 5:53 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Hi,

I am trying to use below repository document or and facing below error when I try to run the excel on the server where BO application is installed.

This workbook has lost its VBA project ,Activex control and programmability related features.

[/img]
Back to top
interactive
Senior Member
Senior Member



Joined: 28 Apr 2005

Posts: 88
Location: USA


flag
PostPosted: Tue Mar 20, 2018 4:30 pm 
Post subject: Re: SAP BI Repository Documentor

I know this a old post, but does anyone have a solution for this issue. ?

I am running into the same problem, however I am not sure if this is because I am using a WIN 10 client machine that has Office 2016, or if this is because the information that is being retrieved is from BOE 4.5 SP05.

Experts......Please help me
Back to top
jacey41
Forum Member
Forum Member



Joined: 15 Jun 2012

Posts: 2



PostPosted: Mon Mar 26, 2018 1:33 pm 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

A novice looking for help from experts - DO do I need loaded on my computer to run the Documentor? Does the server need anything else other than BI?

I am running Excel 2010 and BusOBj 4.0

Thank in advance for you help.

Jacquie
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14080
Location: England


flag
PostPosted: Mon Mar 26, 2018 2:13 pm 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

You don't need anything extra on the server, you need the client tools on the machine that you are running Documentor on.
_________________
Available for contract work now.
Back to top
RensH
Principal Member
Principal Member



Joined: 18 Jun 2007

Posts: 136


flag
PostPosted: Fri Jun 22, 2018 4:55 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

veparala wrote:
I am getting the below error when i tried to run this excel

VBA Project - 1004: Application - defiled or object -defined error 1000095

Excel 2010
BI4.1 SP6

Anybody got this error and resolved it?

Thanks
Venkat


Exactly the same error using BI 4.1 SP5 (yes it's old, upgrade planning has been shifted several times ... )
Excel is 2016 here.
It's a localized (Dutch) version , that might trigger another problem (and yes I had to translate the error message to find a macht with this one - MS translation of error messages is ... like a google translate of it)

I get SOME results in the excel, though, before it bails out :

- 1st tab MAIN is populated with my new choices in the "run" fields.
- 2nd tab Documents : 2338 lines
- 3rd tab Universes : ------------------------ EMPTY except for headers ?
- 4th tab Categories : ------------------------ EMPTY except for headers ?
- 5th tab Connections : ------------------------ EMPTY except for headers ?
- 6th tab QaaWS : ------------------------ EMPTY except for headers ?
- 7th tab Disk Usage by Group :
FIRST a "circular reference" warning, then
"Total MB" filled as 9.536,74 ( is that "only" 9Gb of documents ? ) and 2 big blue full circles showing 0 space available, 0 space used ?

- 8th tab DocDetails : 7609 lines
- 9th tab Usage by user : ------------------------ EMPTY except for headers ?

Is there a way to make it work on BI 4.1SP5 ? Or do I just have to wait for the upgrade to be approved and installed ?
( BIPST needs extra server config, so gives only partial data as well )

_________________
XI 4.1 (SP5)
(Mostly WebI docs using universes, no voyager etc -yet- but (very few) dashboards )
LDAP eDirectory , repository on oracle.


Phasing out: BO-XI 3.1 SP6 . Mostly Webi.
Phased out: BO651, full clients. No Webi.
Back to top
RensH
Principal Member
Principal Member



Joined: 18 Jun 2007

Posts: 136


flag
PostPosted: Fri Jun 22, 2018 7:09 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Seagrass wrote:
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

Same here, BI 4.1 SP5 :
limit the results using DATE fields, and ... see previous reply: 2000 lines in "documents", 7500 lines in "document details", "circular references" on the disk usage chart page, empty for everything else, AND bail out with an error.

I read your remark, and tried "without dates" : BINGO !
It finds 104 universes, 10.000 documents (try a different limit ?) , 22 categories, some 40ish connections,
The only measure that is not even "close" is .... "disk space" : ALL of the space occupied by universes, nothing by (over 200) webi reports ?
But it's getting better.

We now - finally - have a "view on the system"
It does NOT show "frs/Output" (instances) and does not give info on universes or documents "not opened since ... " but hey, it's a free tool and gives a lot of details already.

THANK YOU all for developing this and tweaking it (commenting the tweaks here) to keep it alive.

_________________
XI 4.1 (SP5)
(Mostly WebI docs using universes, no voyager etc -yet- but (very few) dashboards )
LDAP eDirectory , repository on oracle.


Phasing out: BO-XI 3.1 SP6 . Mostly Webi.
Phased out: BO651, full clients. No Webi.
Back to top
RensH
Principal Member
Principal Member



Joined: 18 Jun 2007

Posts: 136


flag
PostPosted: Tue Jun 26, 2018 6:19 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

RensH wrote:
Seagrass wrote:
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


A little less happy after some extra runs.
First I hit a "10 000 documents limit" , but that was only "the default limit" given in the macro.
So I upped it.
first run : try 99 000 , should be enough.
That ran a very long time, showing (in Progress panel) that 99 000 was too high an estimate: it found "only" 47756 documents.
after - again - a really long time, it BAILED OUT, again, with the same error.
Limiting to 25 000 was fine, filled the sheets, but ... listed partial results only.
Hey, now there was more diversity in the "storage" compartment.

Running again with limit 50 000 (slightly OVER the number found in previous run) ... bailed out AGAIN

Sorry, a bit frustrating there, but the comment still holds: for WHAT it finds, it is GREAT !
Thanks, developers !

THANK YOU all for developing this and tweaking it (commenting the tweaks here) to keep it alive.

_________________
XI 4.1 (SP5)
(Mostly WebI docs using universes, no voyager etc -yet- but (very few) dashboards )
LDAP eDirectory , repository on oracle.


Phasing out: BO-XI 3.1 SP6 . Mostly Webi.
Phased out: BO651, full clients. No Webi.
Back to top
spmp007@me.com
Forum Member
Forum Member



Joined: 21 Sep 2016

Posts: 13



PostPosted: Fri Aug 03, 2018 4:52 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

I know the libraries changed - i have other little programs like this that have been affected.

Will try your fix but if not, can you share your xlsm?
Back to top
HetalKataria
Forum Member
Forum Member



Joined: 17 Oct 2017

Posts: 2



PostPosted: Fri Aug 10, 2018 6:04 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

Hello,

I tried using BI reposiotry documentor and here are my observations:

SAP BO version : 4.1 SP 1
Mircosoft Office version : MS Office Professional Plus 10

I extracted the SAP BI docuemnt folder and then copied it to the BO server.
When i ran the excel, entering the csm(hostname), user ID(having admin rights) and password, it threw below error :
This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.

To resolve this issue, go to Open Control Pane-->Programs and Features-->Select Microsoft Office and click Change in the menu at the top, or right-click Microsoft Office and select Change-->Select Add or remove features and click Continue.-->n the list that appears, click the plus sign to expand Office Shared Features-->Click the drop-down arrow next to Visual Basic for Applications and change it to Run from My Computer. Click Continue

After few mins, change will be completed and close the excel.

Now, open the docuemnt and it opens without any error.
Click on Get Document Details Button

Entered CMS,SUerName,Password.
It started to complie data and as soon as it started collecting data for conenctions, it threw an error.

Complie error:User-define type not defiend.

But, next time when i try to run, the excel i ented the dates, and selected only uniserse. it ran and populated data in universe tab.[/img]
Back to top
spmp007@me.com
Forum Member
Forum Member



Joined: 21 Sep 2016

Posts: 13



PostPosted: Tue Aug 28, 2018 3:14 am 
Post subject: Re: SAP BI Repository Documentor

Hi, this doesn't work from 4.2 SP4 onwards, any chance of an update please?
Back to top
spmp007@me.com
Forum Member
Forum Member



Joined: 21 Sep 2016

Posts: 13



PostPosted: Tue Aug 28, 2018 3:15 am 
Post subject: Re: SAP BI Repository Documentor

Its def the change in the libraries. We have SP5 and other Java based utilities that had to be rewritten.
Back to top
spmp007@me.com
Forum Member
Forum Member



Joined: 21 Sep 2016

Posts: 13



PostPosted: Tue Aug 28, 2018 4:33 am 
Post subject: Re: SAP BI Repository Documentor - SAP BI BusObj 4

It doesn't like to run on a 64bit machine either. We have office 2016 and 4.2 SP5.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 5 of 5 All times are GMT - 5 Hours
Goto page Previous  1, 2, 3, 4, 5
 
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.0419 seconds using 17 queries. (SQL 0.0077 Parse 0.0010 Other 0.0332)
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