VBA Code to Access Universe Objects

[system]

Hi,
I wanted to know whether is it possible to access the universe objects, I mean classes, objects, joins etc, using the VB editor provided by Business Objects. My aim is to compare 2 versions of universes and create a report based on the comparison. By comparison I mean to verify the number of joins, number of contexts, number of objects etc.
Can any one please help me out in doing this. I just can’t understand how to start with it…

---

jjagadish (BOB member since 2006-03-06)

[system]

This post should solve your purpose:

120×120 10.4 KB

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…

---

shamit (BOB member since 2004-07-01)

[system]

Yes you can easilly access universe objects and classes, but if you want to make a good comparision you might also compare the objects properties like select and where.
I did it in one of our products, really nice but it can take some time to scan a big universe

Regards, JP

---

jp.golay (BOB member since 2002-06-17)

[system]

Hi JP,
As you might are aware of, my aim is to build a utility which can compare different version of the same universe. But the issue is that, the comparison is to be done in a machine which does not have BO Installed in it.

I was wondering whether there is any way to compare the universes without installing BO in the server. I came to this question because I am sure that there will be some dll which is used by the VB Application to access the universe Objects. If we have this dll registered in the machine then do you think that the application will work with out having BO Installed in it?

Jiju Jagadish
jiju.jagadish@cgi.com

---

jjagadish (BOB member since 2006-03-06)

[system]

@jjagadish

If we have this dll registered in the machine then do you think that the application will work with out having BO Installed in it?

This can get messy with respect to licensing. Copying DLLs around without installing the product might break license.

On the other hand, BO expoes reporter APIs through busobj.exe (and not through some DLL)

And if that is the sace with Desiger API then you will need to install designer.

---

shamit (BOB member since 2004-07-01)

[system]

You can do something in comparing the universes in the repos tables but it will only works till 6.x not anymore in XI

I was wondering whether there is any way to compare the universes without installing BO in the server. I came to this question because I am sure that there will be some dll which is used by the VB Application to access the universe Objects. If we have this dll registered in the machine then do you think that the application will work with out having BO Installed in it?

No they need designer.exe installed and the application need a ton of dll’s

If you are looking for a solution we have developped a too called Version Manager than can compare universes contents, very easily, have a look at http://www.ebiexperts.com. Also Noad have a solution.

Hope this help,

JP

---

jp.golay (BOB member since 2002-06-17)