Alphabetizing the Classes and Objects in a Universe?

building semantic layer
1

Hi,

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.

sskchak (BOB member since 2004-06-21)

2

It can be done, but not easily.

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 Krandel :us: (BOB member since 2002-06-25)

3

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.

kashif

Kashif Saeed :pakistan: (BOB member since 2004-06-02)

4

It can be done, but not easily.

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.

regards
Kiran

kiran_tc (BOB member since 2005-01-15)

5

I don’t know of any way other than manually to do this. Perhaps the Designer SDK could be used.

But, I can guarantee this is a bad idea. Don’t let users make these sort of decisions. Show them alternatives and you’ll be better off.

Steve Krandel :us: (BOB member since 2002-06-25)

6

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.

Nope, no way to do it automatically.

Chris Pohl :us: (BOB member since 2002-06-18)

7

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.

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

8

Another reason against do it is that the default hierarchies for drilling in the universe are taken from the order of objects…

Eileen King :us: (BOB member since 2002-07-10)