BusinessObjects Board

Documenting the Universe from Repository

security Supervisor (4.x - 6.x)
#1

Is there a way to fetch the information on a universe and dump into an xls sheet.
e.g the Universe has following structure.


    Country
    |   Country Name
    |   Country type
    |--States
    |          State Name
    |          State Type
    |--County
    |   |     County Name
    |   |     County Type
    |   |--City
    |              City Name
    |              City Type
    |--Region
               Region Name
               Region Type

I want to dump the information in an excel sheet in the same hierarchical manner.
The excel sheet should look like this.


Country|        |      | Country Name
       |        |      | Country Type
       | States |      | State Name
       |        |      | State Type
       | County |      | County Name
       |        |      | County Type
       |        | City | City Name
       |        |      | City Type
       | Region |      | Region Name
       |        |      | Region Type

Is there any easy way to do it? Probably by creatinga BO Report.

2.) How can I find out what level of nesting is done in creating sub classes? e.g. In the above example, we have subclasses nested upto 3rd level. (Country -> County ->City)
How can I find out what is the maximum level of nesting done in the entire universe?

Thanks,

mkumar (BOB member since 2002-08-26)

#2

If you are on Oracle, you can start with the managero.unv universe. Create a table with your objects and then start formatting it appropriately.

Judy

JMulders :us: (BOB member since 2002-06-20)

#3

We are on Sybase 12.5

mkumar (BOB member since 2002-08-26)

#4

I posted some SQL here https://bobj-board.org/t/9516 which may give you a start.

BTW, email me at karen.george@sscims.com if you’re who I think you are! I should be in your email address book because I think you’re in mine!

KSG :us: (BOB member since 2002-07-17)

#5

Repository reporting questions go in the Supervisor forum. Moving. 8)

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

#6

Hi

For a VBA solution you can also adapt the code published in the BOB downloads topic “Mass update to object names / descriptions”

This uses the Designer Object Model and handles tree navigation

HTH

ottoman

Ottoman :uk: (BOB member since 2002-10-04)

#7

Check out this utility: Mass Update of Objects/Descriptions in Excel
It doesn’t do the indenting, but it’s an easy way to get your universe into Excel

Chris Pohl :us: (BOB member since 2002-06-18)

#8

This code has been most helpful.
I was able to modify the code to do some fancy formatting. Like showing the data in hierarchical manner and do bordering around occupied cells to have a better print out version.

mkumar (BOB member since 2002-08-26)

#9

Feel free to submit or post your modified code 8)

Andreas :de: (BOB member since 2002-06-20)

#10

If you want to post your version of the code in the board library, send it to bobdownloads@forumtopics.com

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

#11

Surely, I will be happy to share afterall I took most of the hints from Bob only :mrgreen:
This may not be the bese piece of code but it worked for me.
This code is written for Sybase. But the connection string can be modified to make it work with other databases.

I have sent the code to bob downloads.

mkumar (BOB member since 2002-08-26)