system
April 26, 2010, 8:12pm
1
In 6.5 I had a copy of this report that would dump a universe to Excel. It doesn’t work in XI and I’m struggeling to find a way to do it. What is easiest way to do this? All I need is class / object / type / select & where.
Thanks!
biketrip (BOB member since 2007-09-14)
system
April 26, 2010, 8:22pm
2
There is an XI-friendly version in BOB’s Downloads.
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…
Dave Rathbun (BOB member since 2002-06-06)
system
April 26, 2010, 8:30pm
3
Thanks much! I downloaded and tried to run, get…
VBAProject - 430: Class does not support Automation or does not support expected interface.
I read in one of your posts it has to do with some of my PC settings. Not sure I understand it all, but I will dig into that.
Thanks…
biketrip (BOB member since 2007-09-14)
system
April 26, 2010, 8:43pm
4
If you have further questions about using the code, it’s best to post in the topic related to that utility.
Dave Rathbun (BOB member since 2002-06-06)