BusinessObjects Board

Document a universe using Excel and the Designer SDK

downloads
#35

yes i have BOXI installed … i .e i have designer installed… on my machine…

as soon as i click it its opening a vb page

rajesh_tns (BOB member since 2008-06-18)

#36

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?

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

#37

How do I obtain this Excel file? Does it work with XI R2?

viewlakes (BOB member since 2004-01-28)

#38

Look at the start of this topic for both downloads and additional information. :wink:

Anita Craig :us: (BOB member since 2002-06-17)

#39

How can this code be modified to display the unique ID of an object?

jason_west :us: (BOB member since 2008-01-22)

#40

There is a hidden property (cleverly) named .Id (Obj.Id) that you can add to the utility as another column.

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

#41

Sweet! Thanks mann.

jason_west :us: (BOB member since 2008-01-22)

#42

Thanks Dwayne! Works Great!! :smiley: :cookie: :mrsbob:

eye_candy :us: (BOB member since 2005-03-18)

#43

Thanks for this great tool.
Is it possible to document Object Level and Row Level Restrictions also.

mukul.jain :india: (BOB member since 2005-10-26)

#44

[quote:741c53dfc4=“mukul.jain”]Thanks for this great tool.
Is it possible to document Object Level and Row Level Restrictions also.
[/quote]

Yes, but not with this tool. Those restrictions are stored separately in the repository, not as part of the universe itself.

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

#45

Can that be extracted using CI_SYSTEMOBJECTS or there is something else.

mukul.jain :india: (BOB member since 2005-10-26)

#46

[quote:ddb340bf69=“mukul.jain”]Can that be extracted using CI_SYSTEMOBJECTS or there is something else.
[/quote]

I believe there is some sample Enterprise SDK code here on BOB relating to universe restrictions. Try to search, and if you can’t find it maybe someone else can suggest keywords to use.

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

#47

Hi Dwayne Hoffpauir,
Even I got the same error but my problem was different.
[b]
Failure in ListContexts()

VBAProject- -2147417851: Automation error
The server threw an exception. [/b]
In my Universe we have about 8 to 10 context. But when I try to document the universe everything looks fine except the context.
When I document universe it shows only 2 contexts.
Please help me with this issue.

Thanks,
GNK_BO.

GNK_BO (BOB member since 2007-07-17)

#48

Is there anything unusual about the joins in those contexts (like really long SQL)? Otherwise, I can only guess that the universe itself is corrupted. Can you try deleting the contexts in the universe and re-creating them? Or maybe re-import a clean copy of the universe? Or try the utility on another machine?

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

#49

Hi Dwayne Hoffpauir,
Thank you for your response.
Well we do have few sql queries which are big in the joins. For instance we have few complex joins in the universe.
I will try your other options and check with that options too.
Thank you for your help.
GNK_BO.

GNK_BO (BOB member since 2007-07-17)

#50

To get this to work in Business Objects XI 3.0, it looks like you just have to update the project references to point to the “BusinessObjects Designer 12.0 Object Library”.

Dwayne, can you post the XI 3.0 version? Or alternatively I can send you the file to post. Thanks in advance.

RufusLancaster :us: (BOB member since 2005-11-02)

#51

Not sure another version is needed. Changing the library seems to only be needed if multiple versions like XIr2 AND XI 3.0) are installed on the same machine. I updated the description in the first post with that information.

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

#52

Thanks Dwayne.

RufusLancaster :us: (BOB member since 2005-11-02)

#53

Hi Dwanye, I was having the same problem - I am receiving an error message when I try to run the ‘Document a Universe’ for XIr2.
The message I get is 'VBAProject - 2147417851: Automation error. The server threw an exception.

I updated the code as you suggested on the board as I believe I have object descriptions longer than 1024. I am still getting the error.

Any suggestions?

Sarah_Helpme (BOB member since 2006-11-09)

#54

After it errors, is there SOME partial data on the Excel tabs? Also, try stepping through the code line-by-line (F8 key in the VB Editor). Knowing which line is throwing the error may help figure out why.

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