system
June 23, 2008, 3:49pm
1
I am using a macro to document a universe, in MS Excel. I am doing some changes in the excel file. Is there a way to write it back to the universe using macros?
trigger (BOB member since 2008-06-05)
system
June 23, 2008, 3:57pm
2
Sure, in fact you can download some examples… first, this one extracts information from a universe:
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…
This one can be used to publish help text (object descriptions) back to the universe:
Update 23-Oct-2009: Another version that can change CLASS names and descriptions can be found here later in this thread.
Author: Dwayne Hoffpauir, EDS Corporation
Further discussion on this utility should take place in this topic .
Author Notes:
Option Explicit 'require variables to be declared before being used
Dim DesignerApp As Designer.Application
Dim Univ As Designer.Universe
Dim Wksht As Excel.Worksheet
Sub GetInfo()
Set DesignerApp = New Designer.Application
…
Dave Rathbun (BOB member since 2002-06-06)