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.

Document a universe using Excel and the Designer SDK
23 members found this topic helpful
Goto page Previous  1, 2, 3, ... 20, 21, 22  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
Ramprasad
Forum Member
Forum Member



Joined: 25 Jan 2008

Posts: 11



PostPosted: Mon Apr 28, 2008 4:39 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi Dwayne Hoffpauir,

Thanks for your reply.

I changed the Macro code,still i am getting the same error.




Thanks,
Ram
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Mon Apr 28, 2008 7:29 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Ramprasad wrote:
I changed the Macro code,still i am getting the same error.

I can only suggest that you step through the code, and report back exactly which object, property, and value is causing the problem. I may be able to offer a solution with that information.

_________________
Dwayne Hoffpauir
Image link
Back to top
lindacaron
Senior Member
Senior Member



Joined: 16 Jul 2002
ASUG Icon
Posts: 41
Location: Dallas, TX


flag
PostPosted: Thu May 08, 2008 9:43 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Dwayne,
I used the download for 6.5 and it worked great for the first universe I tried. But when I run it against a much larger universe, it gives me a "Failure in ListObjects(): "VBAProject 7 - out of memory" error. Do you know of a way to get around this? Does it mean physical memory on my PC (it is rather old).
Thank you so much, Linda

_________________
Linda M. Caron
Sr. BOBJ Developer/Business Analyst
Back to top
rpothineni
Senior Member
Senior Member



Joined: 02 Jan 2008

Posts: 40


flag
PostPosted: Fri May 09, 2008 2:39 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi

I get the error:

"Compile error: Can't find project or Library"
with this part of code highlighted:

For this how can i include the business objects library ?

Adv. Thanks
Raghu
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Fri May 09, 2008 9:26 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

lcaron wrote:
Dwayne,
I used the download for 6.5 and it worked great for the first universe I tried. But when I run it against a much larger universe, it gives me a "Failure in ListObjects(): "VBAProject 7 - out of memory" error. Do you know of a way to get around this? Does it mean physical memory on my PC (it is rather old).
Thank you so much, Linda

Might the discussion here explain it?

_________________
Dwayne Hoffpauir
Image link
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Fri May 09, 2008 9:29 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

rpothineni wrote:
"Compile error: Can't find project or Library"
with this part of code highlighted:

For this how can i include the business objects library ?

You do have Designer installed on the machine, correct? In the VB Editor, go to Tools, References and be sure the proper library is selected. If that doesn't explain it, might you have more than one version of Designer installed on the machine?

_________________
Dwayne Hoffpauir
Image link
Back to top
fred2602
Forum Member
Forum Member



Joined: 22 May 2008

Posts: 3
Location: Brussels


flag
PostPosted: Thu May 22, 2008 8:21 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi everyone,

I have some troubles to run this document generator.
My configuration is the following:

- Business Objects: 6.1
- System: Windows 2000

I am using the excel version 6.5 and i got this error after clicking the push button "Document a universe", as my VBA knowledge is not so bad, i have track the debug, and it appears that it's just blocking at the first interesting line of the code: Set DesApp = New Designer.Application

This is the error I get:

Image link

and the references I am using in my VBA:

Image link

I have only one Application Designer 6.1 installed

I have checked the MDAC (2.7 Refresh) etc.. and i have looked into the web, but I can't find the solution..

Thanks for your advise

Ps: It gives me the same error with the word document generator.. and the compilation of the vba runs correctly


Last edited by fred2602 on Thu May 22, 2008 8:34 am, edited 1 time in total
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Thu May 22, 2008 8:34 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Welcome to Bicon_mrgreen.gifB!

V6.1 was one of the buggiest releases ever, so this may just be another "symptom" of that release. That said, there is no reason to have the BusinessObjects 6.0 Object Library selected. Only the Designer object library is used by this utility. Since the original was done with 6.5, you might try de-selecting even the Designer library (then maybe save, close, re-open Excel), then re-selecting the Designer library.

Just a couple of ideas.

_________________
Dwayne Hoffpauir
Image link
Back to top
fred2602
Forum Member
Forum Member



Joined: 22 May 2008

Posts: 3
Location: Brussels


flag
PostPosted: Thu May 22, 2008 8:50 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Thanks for your quick reply. I have tried your way, but still getting these errors..

And thanks for the info around 6.1, as this version has been implemented by our payroll provider.. I understand why they want to upgrade their clients to XI in the near future icon_smile.gif
Back to top
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Thu May 22, 2008 9:45 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

fred2602 wrote:
Thanks for your quick reply. I have tried your way, but still getting these errors..

Try starting with the v5.1 version instead of the v6.5 version. Just a thought ... grasping here.

_________________
Dwayne Hoffpauir
Image link
Back to top
fred2602
Forum Member
Forum Member



Joined: 22 May 2008

Posts: 3
Location: Brussels


flag
PostPosted: Thu May 22, 2008 9:53 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Already tried icon_wink.gif but thanks
Back to top
DOTJake
Senior Member
Senior Member



Joined: 07 May 2004

Posts: 94
Location: Wisconsin


flag
PostPosted: Fri May 30, 2008 8:14 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

I am also having the same problem with the "430 Class does not support ..." error. I am on XI r2 sp3. I can run it on some of our PC's but not on all. We are all on the same version of XIr2 but also use Crystal and Xcelcious. I opend a case with BO tech support on this yesterday and they sent me a program (Modules.exe) to show what DLLs are loaded by applications to see if there are any differences between the machines where it will work and those where it won't. It may have something to do with the order that our products were installed. I won't get a chance to check it out until next week but I'll post if I find a solution.

Has anybody else had any luck with solving this problem?

DOTJake
Back to top
DOTJake
Senior Member
Senior Member



Joined: 07 May 2004

Posts: 94
Location: Wisconsin


flag
PostPosted: Mon Jun 02, 2008 3:55 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

I have resolved my "430 Class does not support ..." error. I had also been having problems with getting all the way through the Import Wizard and was instructerd (by Bus Obj tech supprt) to uninstall all my Business Objects, Crystal, and Xcelcious reports desktop applications and re-install them in a specific order (Crystal reports, Then Bus Obj client tools, then Xcelcious). Apparently there my be conflicting DLLs. This fix for the Import wizard also fixed my '430' error.

I'm on XIr2 SP2 and Crystal XI.

Hope this helps.

DOTJake
Back to top
Mike Murray
Principal Member
Principal Member



Joined: 23 Dec 2005

Posts: 472
Location: Des Moines Iowa


flag
PostPosted: Thu Jun 12, 2008 12:48 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Where can I find the description for the numeric values brought back in the cardinality and outerjoins columns?
_________________
Mike Murray
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22161
Location: Dallas, Texas


flag
PostPosted: Sun Jun 15, 2008 9:24 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Mike, those should be detailed in the "Object Browser" of the Designer SDK. While you have your Excel file open, go into the macro code and click the Object Browser menu option. I think that's the correct text. From there you can search for the various cardinality or other values and see how they are assigned.
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 2 of 22 All times are GMT - 5 Hours
Goto page Previous  1, 2, 3, ... 20, 21, 22  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.0927 seconds using 17 queries. (SQL 0.0019 Parse 0.0634 Other 0.0274)
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