BusinessObjects Board

Document a universe using Excel and the Designer SDK

downloads
#72

Interesting utility!! Dwayne.

It worked wonders. :+1:
Now, I just need to make a few modifications to complete the Universe Design Document required by my boss.

Thank You.

-SaiSravan

SaiSravan :india: (BOB member since 2008-10-20)

#73

Hi,

When i tried to run XIR2 macro, igot error"VBAProject-430: Class doesn’t not support Automation or does not support expected interface" how to resolve this?

Regards,
GGS

Arasu (BOB member since 2008-10-24)

#74

Excel 2007 by chance?

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#75

This is awesome, exactly what I needed. BOB forums rock yet again!

river-wind (BOB member since 2007-07-24)

#76

What a wonderful tool, have been looking for this for a while. Is there any way we could do the opposite, i.e add objects, classes in the Excel file, upload to BO universe, ie partially creating a BO universe via Excel?

thanks,
plexi 8)

pleximax :norway: (BOB member since 2004-08-20)

#77

Possible? Yes … see Create Class and Objects Automatically.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#78

Thanks for this excellent thread. Helped as a reference/starting point for a Universe re-engineering work (from Oracle to SQL server + breaking down a large universe into small manageable universes), having 2300 objects, approx 400 table, 500 join, 250 conditions, having Oracle specific syntaxes all over.

Thanks a lot for support, new contributions and improvements to previous posts.

-Guna

vigi_guna :australia: (BOB member since 2008-07-09)

#79

Dwayne:

I have downloaded the “Document-a-Universe” for XIR2. I am currently using XI R3.

When I clicked “Document a Universe” button from the excel, logged onto the CMS Server and selected the universe.
Once it processed and returned the error message

Buffer overrun detected
Program: $PATH\designer.exe
A buffer overrun ahs been detected which has corrupted the program’s internal state. The program cannot safely continue execution and must now be terminated.

Is this error message normal or I need to configure anything before executing this program. I am using the XI R3 under XP environment.

The program still downloads the information in the tabs and it appends the information with existing universe information. Is it normal operation ?.
Please confirm.
Thank You
Ramesh Vasudevan

rameshbalajiv (BOB member since 2008-03-25)

#80

Now that is a new one. I’ve not seen that error before. I suspect something corrupt on your workstation, but there is one thing to try. Could you run the utility on a very small, simple universe, and see if it generates the same error? The utility is recursive (calls itself as it moves down the folder tree), but if the error persists on a small universe, it eliminates the possibility that you’ve run out of memory.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#81

Hi:

Now that is a new one. I’ve not seen that error before. I suspect something corrupt on your workstation, but there is one thing to try. Could you run the utility on a very small, simple universe, and see if it generates the same error?

I tried small to medium size universes, got same error message every time.

In fact, I downloaded other utilities like WD Scanner, got the same error message once it completes the execution.

The utility is recursive (calls itself as it moves down the folder tree), but if the error persists on a small universe, it eliminates the possibility that you’ve run out of memory.

I have 4 GB of memory on my box. I will try investigate further again.

Regards
Ramesh Vasudevan

rameshbalajiv (BOB member since 2008-03-25)

#82

… and the WID scanner doesn’t even use Designer (I don’t think). Sounds more and more like a local workstation issue, I’m afraid.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#83

Hi,

when i am working with to dowload a universe as excel document of XIR2 universe the following error was coming. please can u give me a solution to resolve this problem.

( VBAProject - 430 : class does not support automation or does not support expected interface )

regards
sekhar
[/u]

bsekhar1980 (BOB member since 2009-01-16)

#84

Hi Dwayne

I get the same error as well

VBAProject - 430 : class does not support automation or does not support expected interface

Using Excel -2007 and on another PC Excel 2003. Get the same error both ways.

The library is fine, it does use The BOXI one. The compiler highlights the first line of code
Sub DocumentUniverse()

How do I fix this?

meenal (BOB member since 2006-03-08)

#85

Hi,

When i tried to Document a universe.

i am getting the following error

VBAProject -430 : Class does not support Automation or does not support expected interface.

universe version : XIR2

Please help me on this…

vickys (BOB member since 2007-11-08)

#86

Questions for bsekhar1980, meenal, vickys. What version of Excel? I know meenal said both Excel 2003 and Excel 2007 give the error, but I have my doubts about Excel 2003 giving that error.

I get the error universally (pun intended) with Excel 2007. Honestly, haven’t had the time to see if BusObj is aware of the issue.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#87

Hi Dwayne,

I am using MS office Excel 2003 SP2.
Any suggestion for resolving this problem is appreciated…

Compiler highlight below line :

Set DesignerApp = New Designer.Application

Thanks

vickys (BOB member since 2007-11-08)

#88

I’m at a loss, since I use that version of Excel myself, and I’m guessing the majority of the thousands of downloads do as well.

I can only suggest typical debugging at this point, like trying on a co-worker’s machine, download a clean copy, etc.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#89

Thanks,BUT,I did not get the information of Derived Tables in that,just the tables,columns from pointing do Database,Please can you tell me how to find the Derived Tables?

Naveen Vanaparthi (BOB member since 2008-07-02)

#90

Thanks,thats a good tool,BUT How to get information of DERIVED TABLES?

Naveen Vanaparthi (BOB member since 2008-07-02)

#91

Hi, posting your question twice isn’t really going to help get it answered any quicker … and especially not when the answer to your question lies within the very same thread you asked the question in :roll_eyes:

HINT: Try page 5 and see if that helps :wink:

Peter Hughes :uk: (BOB member since 2005-11-21)