Document a universe using Excel and the Designer SDK

system · January 13, 2009, 2:53pm

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)

system · January 13, 2009, 3:44pm

… 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 (BOB member since 2002-09-19)

system · January 19, 2009, 5:53am

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)

system · January 19, 2009, 2:07pm

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)

system · January 20, 2009, 10:33am

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)

system · January 20, 2009, 1:52pm

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 (BOB member since 2002-09-19)

system · January 21, 2009, 9:04am

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)

system · January 21, 2009, 1:55pm

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 (BOB member since 2002-09-19)

system · January 23, 2009, 3:27am

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)

system · January 23, 2009, 2:32pm

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

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

system · January 27, 2009, 11:50am

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

HINT: Try page 5 and see if that helps

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

system · January 27, 2009, 12:31pm

sandeepk66, please do not bump your post until at least one business day has passed.

Nick Daniels (BOB member since 2002-08-15)

system · February 11, 2009, 2:03pm

I am trying to document a XI 3.1 universe, but I am getting an out of memory error. It is in the LictConditions() section.

Franko418 (BOB member since 2004-07-07)

system · February 11, 2009, 11:27pm

Thanks

I was wondering if there is any tool that can document by report name, the corresponding classes/objects & the table/column name. i.e. Excel with report → class/ objects used → Table.column name? The reason for this is I am looking at 250 odd XIR2 reports that needs documenting.

pravin_kadambi (BOB member since 2005-05-18)

system · February 12, 2009, 2:20pm

Assuming you mean full client reports, look here … List objects used in a series of reports. If you mean WebI reports, there is also a WID Scanner tool here in BOB’s Downloads.

The full client utility will document the classes / objects used, but not the tables / columns directly. Remember, a single universe object could reference many tables / columns. That said, you could use the output from the full client documentation and link it (on your own) to the universe documentation, and get very close.

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

system · February 12, 2009, 3:00pm

Thanks Dwayne. As you rightly said, I can get pretty close

Anyway, two awesome contributions from you. Hats off!!!

pravin_kadambi (BOB member since 2005-05-18)

system · February 16, 2009, 3:07pm

This was great information and this macro worked wonders for me. Just wanted to say thanks

klongmire (BOB member since 2009-02-09)

system · February 19, 2009, 9:42am

while running the excel sheet for XIR2 which u posted the execution was failing at the end so can you please check and send me the correct one
it would help alot for me

Thanks & regards
krishna
09620202420

ummalety (BOB member since 2009-02-19)

system · February 19, 2009, 2:04pm

While I could be available to do some custom work for you, I’m fairly sure you won’t like my rates!

That said, if you could give me a few more details than “was failing at the end,” I’ll be glad to see if there is anything wrong in the utility itself. Please include what version of the utility, and what version of Designer you are using.

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

system · February 25, 2009, 9:25pm

Dwayne Hoffpauir:

rajesh_tns:
Hi all

After downloading and opening the excel sheet I double clicked on Document a Universe Button then it opened a page and i saw this

Private Sub DocumentUniverseButton_Click()
Call DocumentUniverse
End Sub

what is my next step? how do i go from here to document the universe
Open the workbook, then press Alt-F11 (opens the VB editor). Go to Tools, References, and look for a Business Objects Designer library to be selected. What does it say (what version, etc.)? Go to Debug, Compile VBA project. Any error messages?

I’m having this same problem.

I have Business Objects Designer 12.0 Object Library.

Doesn’t appear to be any error messages (blank pane when I click Compile VBA project).

Thanks,

Moira

moiram (BOB member since 2009-02-20)