Listing objects with SELECT property

[system]

Hey all,

I’ll make a long story short.

I want to list all the objects (dimensions) with their SELECT property to compare with the analysis documents and ETL documents to make sure I have all that’s supposed to be there.

I tried to play with the Print/PDF tab in the Options dialog, but I have all the object properties in a format I can’t really use.

I have over 2500 objects in this Universe so you can imagine if I have to manually validate.

By the way, we’re using BO XI R2.

Thanks.

JFS.

---

JFS (BOB member since 2009-04-29)

[system]

Hi,

Use this utility to document your universe:

Document a universe using Excel and the Designer SDK

Author: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1343]Dwayne Hoffpauir, EDS[/url] 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:5d8cd1056f]Database tables Database columns Joins Contexts Classes Objects Conditions[/list:u:5d8cd10…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

@Marek Chladny

Hi,

Use this utility to document your universe:
Document a universe using Excel and the Designer SDK

Wow! Thanks a lot.

---

JFS (BOB member since 2009-04-29)

[system]

In my universe, I used the “Mapping” text box on the Source Information tab to indicate the source field (s).

I don’t think thi information is available to the users through WebI, but this if this utility could also include the information from the Source Information tab, it would just be too swell. or even a small pop up to select what we want to document…

I tried to modify the ListObjects procedure but could not make it work… I’ll try to work seriously on it when I have some time…

---

JFS (BOB member since 2009-04-29)