Below are the exact error messages I get while accessing the file.
To explain, the BobjClient is installed on the Citrix server and the Excel is on my client machine.
Due to security concerns, I am not able to retrieve the file from citrix environment and I am not able to run the macro.
Please input your suggestions, if any other way round is possible.
This tool works like a charm on XI R2, But when I use the same tool on BO XI R3.1 with Office 2007, it’s throwing the similar error that everyone on this chain is pointing.
Compile Error:
Can’t find project or Library.
I see - Business Objects 11.5 Object library shows “MISSING” on the references. I was trying to locate the dll/exe it was pointing to on the XIR2 machine to see which one is missing on the XI R3.1 machine but couldn’t get it due to the limitation on display on the excel reference.
I see the path seems to be changed from
XIR2 -
C:\Program Files\Business Objects\Common\3.5\bin
TO
XIR3 -
C:\Program Files\Business Objects\Business Objects Enterprise 12.0\win32_x86
Is there any work around for this to get it work on XIR3.
Appreciate any help. Please let me know if need any more info.
Thanks again for the wonderful tool…it saves a hell lot of time on many things.
Nice catch! Other discussions have pointed to the 1,024 character cell limit, but since it has never impacted me I had not researched the exact reason. Thanks for the research, and a simple solution.
If you included the SDK as part of your client installation, it should be a simple matter of going into the Tools, References dialog box (from the VB Editor), de-selecting the library that is labeled misssing, and then selecting its XI 3.x counterpart from the list … BusinessObjects Designer 12.0 Object Library.
Good Morning Folks,
I am in the process of making Data Dictionary based on the existing universe. The excel sheet document has really been helpful to me. The only enhancement I would love to have is to show object universe with their corrsponding table columns. I do not need the select and case statement that comes with coding for object.
So for example:
If universe object is “state ind” and my universe code is "case when state.state_abbreviation = “MN” then 1 else 0 end "…
Here i just want to see :
state_ind => state.state_aabreviation (in the object tab of the sheet)
there is a tool (very similar to Dwaynes one), which has the functionality to report the data lineage.
You can find a brief example here >> http://www.luetzkendorf.eu/download/getsetuniverse/eFashion_v125_20100207_181430.xls
The sheet ‘dependents_eFashion’ contains the lineage analysis for the universe eFashion. For all objects the used tables and columns will be shown. Additionally the objects containing @functions have a reference pointing to the origin objects.
RNola, it sounds like you are working on a universe comparison tool. How did it work out? Are you willing to share it? I am currently working on the same, but it’s always nice not to have to reinvent a wheel.
In case I do have to finish my own, and for my own edification, can you (or someone) point me to the API documentation? I’m currently trying to figure out how where in the property structure to find the ID’s, such as ObjectID, etc. Thanks.
Answered my own question; SDK is here. However, having to sort things by ID for comparison seems to be more work than simply running Dwayne’s original code (with the addition of getting the ID) and pulling that into a database for querying, so I’ve decided to go that route instead. I’m not as much of a VBA programmer as I used to be.
But any other advice on comparing universes is still appreciated.
I just found this forum when trying to search exporting BO universe into an Excel. The Excel Macro works perfetly for R2 universes. Is there a R3 version available? I need to export my R3 universes to Excel. Thank you so much for your help!
All Interested, i had this same error and figure out the solution
Failure in ListObjects()
VBAProject- -2147417851: Automation error
The server threw an exception.
The Errors received are not to do with the VBA, but stem from the default range being restrictive within the objects sheets, meaning an error is returned if large universes are pulled which do not fit. Simply delete the rows e.g. a2;a65536 within the affected sheets. the VBA will then allow the new segment size to fill the abundant space.
i know its an older post, but this is still worthwhile for those searching for this excellent tool, and stumbling during its use.