I am trying to set up a universe for an Oracle Data Source. I have previously only dealt with DB2 data sources. Don’t know if that’s a clue but in the current situation, when I double click on a table to bring it into the Structure Panel from the catalog, the column names come in alphabetical order rather than in the order they are stored in the table. This is confusing for anyone who is already familiar with where the columns fall.
Is this an option I can change? I’ve searched the Designer doc and done queries on this and the B.O. websites but haven’t found any mention of this. Perhaps I’m using the wrong key words???
In a message dated 00-06-20 11:48:32 EDT, you write:
I am trying to set up a universe for an Oracle Data Source. I have
previously only dealt with DB2 data sources. Don’t know if that’s a clue but in the current situation, when I double click on a table to bring it into the Structure Panel from the catalog, the column names come in alphabetical order rather than in the order they are stored in the table. This is confusing for anyone who is already familiar with where the columns fall.
Is this an option I can change? I’ve searched the Designer doc and done queries on this and the B.O. websites but haven’t found any mention of this. Perhaps I’m using the wrong key words???
I don’t get a chance to play with the archives much, but I found this answer there using the search keywords “Designer Column Order”. I have found that the best way to search, although it takes longer, is to use the “substring” search so that you find all forms of words. For example, in this case, the two results from my search used the word “columns” instead of “column” as I entered it… if I had not used the substring search feature I would not have found the answer.
Having said that, there is an answer provided by Luis Gonzales (from BusObj tech support), a frequent contributor to this list. His answer:
An easier way to change the order of the fields from alphabetical to default database order is to modify the *.sbo file (e.g. Ociv7.sbo for Oracle).
Change the ColSort parameter from 3 to 13.
The .sbo file will be found in the Oracle directory of either the Data Access directory (for 5.0) or in the BusObj home directory (for version 4). I’m not exactly sure what the change listed above does, but it works for my installation of Oracle.
Thank you, David, both for the pointer to the answer and the advice on searching more effectively.
I found the .sbo file and made the change. I don’t see any ‘instant’ reordering of my columns. I’m afraid the answer may be that I have to redo my structure definition so that setting is in effect when I do the Insert Table. Please tell me there’s another way!
In a message dated 00-06-20 16:16:56 EDT, you write:
Thank you, David, both for the pointer to the answer and the advice on
searching more effectively.
I found the .sbo file and made the change. I don’t see any ‘instant’ reordering of my columns. I’m afraid the answer may be that I have to redo my structure definition so that setting is in effect when I do the Insert Table. Please tell me there’s another way!
Hmmmm… try selecting View + Refresh Structure from the Designer menu and see if that works.
In a message dated 00-06-20 16:18:01 EDT, you write:
I found the .sbo file and made the change. I don’t see any ‘instant’
reordering of my columns. I’m afraid the answer may be that I have to redo my structure definition so that setting is in effect when I do the Insert Table. Please tell me there’s another way!
Hmmmm… try selecting View + Refresh Structure from the Designer menu and see if that works.
Okay, that didn’t work. Bummer.
Removing a table and reinserting it did work, but that may affect your objects and joins, not to mention contexts, aliases, and so on. It could get ugly.
I am using BO 6.5.1 and Oracle Data base. Object are created in Alphabatical order. I want the objects to be ordered as in the table. can any one help on this.
(BOB member since 2002-08-16)