Document a universe using Excel and the Designer SDK

Author: Dwayne Hoffpauir, EDS Corporation

Notes: The attached utility uses Excel and the Designer SDK to document a universe. Usage is rather straightforward. Click the “Document a Universe” button on the Control Sheet, log in, and select the specific universe. Information will be recorded on separate worksheets for:[list]Database tables
Database columns
Joins
Contexts
Classes
Objects
Conditions[/list]

[Moderator Edit: Added BI4 Download Link in this post - Dave Rathbun]
Document a Universe (XIr2).xls (95.0 KB)
Document a Universe (v6.5).xls (106.0 KB)
Document a Universe (v5.1).xls (106.0 KB)


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

List of objects in the Universe in a spreadsheet?
List of Objects from a Universe
Objects and Description
Documenting Universes
XIR2 Query Builder - SQL Syntax
Extracting table names from universes
Question regarding Documenting a Universe
How to use SDK functionality in BOXIR2??
List of Objects and corresponding tables in Universe
Querying metadata from Universe
how to get tables included in a universe
Technical specs doc
Description classes and objects in the PDF file truncated
Looking for a tool which can document the Full Client report
Save for all users
Listing/printing universe joins
How to find all objects pointing each to which tables
How to export BO class, sub class, objects?
Accessing Metadata in XI 3.0
Macro or program for Universe to Excel export
Calculation of KLOC in Universe
Using Excel to modify and view universe metadata
VBA Code to Access Universe Objects
Associated Objects with @Aggregate_Aware
Object Description Formatting
Extracting Objects with the DB mapping from CMS
VBA Marco
Could we retrieve sql inside the object?
Tool for extraction of universe details
List of Universes - BO 6.5
Designer - List Of Values object
Universe Compare tool
Universe on repository
SDK
How to get Condition Objects using VB script in MS Excel?
Documentation for an universe
Retrieve Object "Description" from the universe in
Error when retrieving List of Values Name with VBA
How to get back universe objects in Excel
Universe Field Listing
how to find out which tables used in a universe?
Universe Docuementor for BI 4.1
Which contexts include a join?
exporting universe structure to excel
BO Universe Extraction through C#
How to get list of table names and schemas used in universe
Download all the universe metadata into excel file
administrative tool - query builder
Query to find Universe Objects and Descriptions
How to assign Unique Names in Universe
Java SDK - How to get a tree of the universe object
SAP BO 4.0 Universe and Report Documentation
Getting List of Names for classes and objects
Class names for Objects in Webi Dataprovider
Class\Object to Spreadsheet
Exporting Names Of Classes and Objects to Excel
How to extract all the table names and joins
To find the Objects associated in Universes and Reports
Documentaion for Universe
How to document an universe details?
my user wants to see all the universes in a excel tabs
Universe designer
Searching universes
Finding the Joins of a table
Universe documentation
Copy objects from one universe to another universe
creating documents for universe
Maintaing the Universe versions
Documenting a universe
what is universe data dictionary??
Getting description of objects in separate fiile
Objects count
Easiest way to dump universe to Excel (XI)?
Universe metrics
Change Select statement in Universe
Managero on BO XI v3
Difference between two versions of a single universe
Query CMS database for SQL used in objects?
List of Tables for a particular universe
Hi how can we get the Universe metadata details, please help
Querying Universe controls
How to do impact analysis in BO?
Document the recent changes made in the universe
Is there an API to get retrieve all the Universe Objects
Object Formatting? Is this new in XIR3?
Printing out/listing contents of a Universe?
Reading variables from a Webi report using the .NET SDK
How to list all database tables all universes based?
Universe COM SDK starting points
Metadata
How can I know in what universe is been used a table?
Universe Source Details
How to see Joins in Designer
how to get "select" and "where" properti
Listing objects with SELECT property
Universe Linking
List of universes
Visible field in a universe
How can I write back to universe
how I can see the repository BO XI R2 on file system ?
Extracting Select Statements
Compare 2 universe
Exporting Universe information to text file
how to document an universe ?
Reporting on the Metadata in a Universe
tables used by universes
Designer XI - Table/Object List
need help on joins
extract the list of the indicator from an uvnierse
Weird report changes
How to set a universe object's tables selection in VBA
WRITING VBSCRIPT(MACROS) IN BO XI R2 UNIVERSE DESIGNER
Comparing universe
Regarding universe documentation
Can a universe or new objects be created using API
BO User Trying to Evaluate Universe Design
How to put this code in loop
Producing low cost universe documentation
Document Table and Column Names for Objects
6.1 Universe Documenter
expose SQl behind an object in the universe
How to get list of all tables used in a given universe
How to get ID’s Object from universe via Designer SDK
universe metadata information using Java SDK
Universe objects and description
Repository tables in XI
Extract universe information from CS/file system?
Searching universes for object names?
Universe Auditing and Meta Data
Macro for Universe
Alphabetized Index to BOB's Downloads
how to compare 2 universes
Utilities/queries to compare two universes
Create universe against CMS
using repository data for external application
List of tables
How to get list of objects and column names
Find a table in Universe
Universe Documentation best practices
"View associated objects" doesn't work
Mass Update Object Level Security XI R2
How can we Export metadata of webi report into XML format?
How to get Metadata of Universe into Excel
List Reports that use a specific TABLE?
Which join is under which Context?
Associating reports with Universe.
making new universe in BO using VBA SDK ??!!!
Report and Universe Meta Data (BOXI)
Is there a managero type universe available for XIR2
Universe Description Uploads
Table Names in Universes
How to list all the objects with physical tables and columns
Extract Metadata from Universe
Reporting off CMS repository
Universe Documentor
Overview universe-objects NOT used in any report
Universe Documentor
Extracting the names of Classes, Objects and Obj Definitiion
Universe Documentation in XI R2
Mapping of Universe Objects to Database Columns (6.5)
Getting Database information for an Object Using VBA
How can i get only the list of class names in the universe?
Get information from Security, Universe, Document domains.
Cannot load linked universes (UNV0011)
Mapping Correspondence

Hi Dwayne Hoffpauir,

Thanks for the spreadsheet.
When I try to execute the attached spreadsheet, I am getting the error
"Run-Time Error ‘91’ "
Cannot Get Mother CLass

Is there any remedy for the same.


Kaustubh_1234 (BOB member since 2008-03-25)

Hmmm … that error happens when trying to find the .Rootclass property for a class that is already at the top level. The code is supposed to trap that error and be able to continue. Any chance that you’ve tweaked the code, and possibly disabled the error handling? Does it happen if you download a clean copy? Be sure you are using the correct version of the utility as well. If that doesn’t fix it, I may have to ask you to send me a copy of the universe causing the problem.


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

Hi Dwayne,

I have downloaded a clean copy and try to execute the same.
I am still having the same issue.


Kaustubh_1234 (BOB member since 2008-03-25)

Kaustubh:

Are you using the correct Library of BO version. (I mean in the Tools–>Reference) ?


BO_Chief :us: (BOB member since 2004-06-06)

And I get the error:

“Compile error: Can’t find project or Library”
with this part of code highlighted:

Sub ListTables(Tbls As Designer.Tables)

Any Ideas please:

Thanks,
brawn


brawnbrawn (BOB member since 2008-03-05)

Do you see this function ‘ListTables’ exists in the code… when you go down in script window ?


BO_Chief :us: (BOB member since 2004-06-06)

Yes, I saw that sub() has been used couple of times in Dwayne’s code.
I get this error when i try to run all the version(Xir2, 6.5 and 5). . Is anything wrong on my PC? or is it for everybody.Any ideas dwayne

Thanks,
Brawn


brawnbrawn (BOB member since 2008-03-05)

Try going into the vba editor of Excel, then under ‘tools…references’ ,make sure you have checked ‘Business Objects Designer Library’. Then try running it. I hope this helps.


Chris_K :us: (BOB member since 2003-01-10)

Hi Dwayne,

Do you also have a similar macro which can be used to document a report.

Thanks.
Manish


manishdarak (BOB member since 2006-03-29)

For universe objects, try this … List objects used in a series of reports
To document more about a report, look here … http://lyontechnologies.com/free_stuff.htm … for the documentation add-in.


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

Hi,

When i tried to Document a universe.

i am getting the following error

Failure in ListObjects()

VBAProject- -2147417851: Automation error
The server threw an exception.

universe version : XIR2

Can any one please help me in this ?


Ramprasad (BOB member since 2008-01-25)

Any chance that the description on an object is extremely long … like more than 1,024 characters?
Try changing the line of code that says this…

Rng(RowNum, 4) = Obj.Description

… to this

Rng(RowNum, 4) = Left(Obj.Description, 1024)

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

what do the following mean in the documenting excel in Objects tab:
Security Access Level(0)/Can be used Result(True/False)/Can be used Condition(True/False)/Can be used sort(True/False)/Show(True/False)

Thanks
Shruti


shruthi (BOB member since 2008-02-25)

All of those are various properties of the object as set up in the universe. If you open a universe and look at the properties tabs (there are several) you should be able to figure it out. :slight_smile:


Dave Rathbun :us: (BOB member since 2002-06-06)

Hi Dwayne Hoffpauir,

Thanks for your reply.

I changed the Macro code,still i am getting the same error.

Thanks,
Ram


Ramprasad (BOB member since 2008-01-25)

I can only suggest that you step through the code, and report back exactly which object, property, and value is causing the problem. I may be able to offer a solution with that information.


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

Dwayne,
I used the download for 6.5 and it worked great for the first universe I tried. But when I run it against a much larger universe, it gives me a "Failure in ListObjects(): “VBAProject 7 - out of memory” error. Do you know of a way to get around this? Does it mean physical memory on my PC (it is rather old).
Thank you so much, Linda


lindacaron :us: (BOB member since 2002-07-16)

Hi

I get the error:

“Compile error: Can’t find project or Library”
with this part of code highlighted:

For this how can i include the business objects library ?

Adv. Thanks
Raghu


rpothineni :india: (BOB member since 2008-01-02)

Might the discussion here explain it?


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