Is there anyway that we could Automate (writing a code) the process of arranging the Classes and Objects in Alphabetical order rather than doing it manually (Drag and Drop). It would be helpful with a universe with large number of Objects. Any Ideas would be helpful.
But, why would you want to? Alphabetizing a universe is generally a terrible idea. Universes should be organized in a logical way that mirrors how users think; not spell.
Steve is absolutely right. Classes and Objects should be organized logically. If you have been requested to do so by the end-users, you need to show them how they can find objects in the object pane by pressing a key constantly…it works exactly the same way as they are going through a list of alphabetically arranged objects.
Pls let me know how it can be done. I have built a universe on 23 tables. Initially I created single class per table. But as per user needs I need to put them in one class and it should be sorted alphanumerically. Each table is having 100 columns on average. How this process can be automated. I dont want to drag and drop.
I’ve done it as an addition to a normal universe.
Create your universe normally, then setup an additional “alphabatized index” group. Then manually copy/arrange the objects alphabetically.
The position of an object within a class can’t be changed with the SDK either, sorry. The information is stored in the OBJ_POSITION field of the UNV_OBJECT table in the universe domain. The only “automated” option I can think of is updating the repository directly … unsupported of course.