Document a BO Universe in Excel

system · July 14, 2011, 5:47pm

Hi Andre,

I did download the excel, added all the BO libraries (12.0) in references. And when I click on Load Universe, I get the error message “Object variable or With block variable not set” (from WriteUniverseXLS - step “Err:”). I tried to de-bug the code by displaying the messages at each step. I believe it is failing in bGetUniverse - Set oDes = New Designer.Application. Any suggestions as to how i can get past this issue…

My current env is :
SAP BO XI 3.1 SP3 installed on Win 2008 server - Windows AD Authentication (I am doing a remote desktop connection to the server)
GetSetUniverse_3_6_04.xls (downloaded on to server)
Office Suite 2007

Thanks

Iceman_9 (BOB member since 2011-07-14)

system · July 18, 2011, 5:41pm

Hi Iceman_9,

the error message points out that you do not have an installation of Designer on the machine you had run GetSetUniverse.

Regards
André

André Lützkendorf (BOB member since 2009-09-28)

system · July 19, 2011, 9:27am

Hi Andre,

I am currently wprking with a c;ient with the New version of BO XI4

I need a Excel document loader for the Universes but getting errors. \In particular when i try to locate the *.UNV file in the local folder there are only .BLx files. I presume that this has been changed from version 3

Is there any way to create a file for the new version as i am not good with VBA.

Much appreciated

Asif

Asif Hameed (BOB member since 2008-07-14)

system · July 28, 2011, 1:39pm

Hi André Lützkendorf!

Not work in Win7, Office2007.
Does not run GetSetUniverse when open Excel file.

obnin (BOB member since 2010-07-08)

system · July 29, 2011, 5:25am

Hi obnin,

please read the manual first. It seems that your version of Excel did disables VBA macros.
Regards

André

André Lützkendorf (BOB member since 2009-09-28)

system · July 29, 2011, 7:37am

Hi André Lützkendorf!

VBA macros are enabled. All DLLs are installed.
Excel BOXI Repository Documentor works fine.

obnin (BOB member since 2010-07-08)

system · August 1, 2011, 9:38pm

Hi obnin,

that sounds good at first.
Do you see the menu item GetSetUniverse after starting the tool?
Do you get an error message after starting one of the makros?
I need more details to unterstand your case.

Regards
André

André Lützkendorf (BOB member since 2009-09-28)

system · August 2, 2011, 7:19am

Hi André Lützkendorf!
Thanks for reply!

The menu GetSetUniverse is not show after starting the tool.
If I run the macros InitBar, menu also does not appear.

The macros ShowCodeDocumentatio work fine - generates sheets.

PS. I have Win7 + Office 2007 SP2 MSO (12.0.6554.5001)

Thanks!

obnin (BOB member since 2010-07-08)

system · August 2, 2011, 9:06pm

Hi obnin,

I have checked this for Win7. Indeed there is a different behavior for showing the menu.
The menu item GetSetUniverse will be shown under Add-Ins.

Regards
André

André Lützkendorf (BOB member since 2009-09-28)

system · August 4, 2011, 8:05am

André Lützkendorf, many thanks!

obnin (BOB member since 2010-07-08)

system · August 23, 2011, 7:30pm

Hi,

First …Thanks a lot for uploading this doc.
I have some issues with this…
it is giving only two tabs of the information.
For the universe test.unv, it is creating only two tabs as Info_test and obj_test.
Is there a way to get the all the tabs?.

Thanks
jp

jpchase (BOB member since 2011-07-25)

system · August 24, 2011, 7:04pm

Hi jpchase,

please read the manual and the outputs of GetSetUniverse carefully.

By using the menu item versioning universe the complete set of data will extracted and saved into an Excel document.

You can manage the type of output under options.

Regards,
André

André Lützkendorf (BOB member since 2009-09-28)

system · September 23, 2011, 8:16pm

Is there an updated version that works with BOXI 3.1 SP3?
I’ve looked thru all 9 pages in this thread and can’t find a compatible version.

Thanks!

Redfish (BOB member since 2011-09-20)

system · October 3, 2011, 4:48pm

yes, you can use version 3.6.04 or Version 3.6.05.
Regards,
André

André Lützkendorf (BOB member since 2009-09-28)

system · October 4, 2011, 7:56pm

Andre,

Does the 3.6.04 version works for excel 2010? we are using BOXI 3.1 SP2. I have tried selecting all the Business Objects references but still getting error: “Object variable or with block variable not set.” can you please help?

Thanks,
Zen.

zenmasterbo (BOB member since 2006-02-15)

system · October 9, 2011, 12:56pm

Hi Ze,

yes, 3.6.04 should work for excel2010.
can you please post the exact error output. The name of the routine which causing the error will be outputted.

Regards
André

André Lützkendorf (BOB member since 2009-09-28)

system · October 20, 2011, 8:42pm

Hi Andre’

I am trying to use your universe documentor but getting error “Object Variable or With Block not set”. Error dialog box has macro name “Writeuniverse XLS”

I am using office 2007 and XI R3 SP2. What should I do. Appreciate your help.

thanks,

Seenu

Seenu Reddy (BOB member since 2011-10-20)

system · October 31, 2011, 1:33pm

I’m having the same problem (Excel 2007). When I try to use

Versioning universe >> xls

I get an error

Run-time error '91':

Object variable or With block variable not set

When I press debug, I get in debug pointing

Err:
    oXls.DisplayAlerts = True

on Private Sub ExportUniverseXLS(). Any ideas how to solve this?

larus (BOB member since 2010-03-31)

system · November 3, 2011, 10:24am

exact same error here…

jornvdd (BOB member since 2003-06-24)

system · November 7, 2011, 2:16pm

I did not have any issue. I have XIR3.1 SP4 & Office 2010. I think we just need to enable Macro when asked during documenting process.

moons (BOB member since 2007-11-08)