Using Excel to modify and view universe metadata

Possible, yes. Supported, yes … if you use the Designer SDK. To my knowledge BusObj does not provide such a solution (interchange with Excel). A couple of examples:
Document a universe using Excel and the Designer SDK
Mass update to object names / descriptions

Not exactly everything you were after, but shows what’s possible. To me, OUT to Excel makes sense … documentation, reference, backup, etc. I’m not as sold on the IN direction though. There is just too much going on with universe design. Thinking all that intelligence can be built with an Excel interface seems more complex than just putting Designer in the hands of those with the right skills.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)