generating table script from universe

building semantic layer
1

Hi

Ist possible to generate create table script based on the classes used in the universe.? Its something like the class name should be the table name and the object name should be column name.
Since there is no option from universe, any chances through macro.?

Regards
Siva.M

looksmee :uk: (BOB member since 2006-02-08)

2

You don’t really have enough information to do that. For example, Designer only has Date, Character, and Number types. Most databases offer char or varchar and a wide variety of numeric types. You also don’t have any precision (length) information. It shoulds like what you want is a way to reverse engineer a database.

Dave Rathbun :us: (BOB member since 2002-06-06)

3

You may want to look at Visio, I believe you can do this sort of reverse engineering with that…

Mak 1 :uk: (BOB member since 2005-01-06)

4

Thanks Dave for your immediate response.

looksmee :uk: (BOB member since 2006-02-08)