BusinessObjects Board

Columns in alphabetical order in Oracle Repository

building semantic layer
#1

Hi All,
for some reason when the repository is in Oracle the column names are coming back in alphabetical order in the pictures of the tables in designer rather than column order. Is there any way to get around this? My diagrams are going to look pretty bad and it’s a lot harder to find the columns when they are not where I am used to seeing them…

Thanks

peternolan9 (BOB member since 2003-02-01)

Column Name sort of Tables inserted into a Universe
Coulmns in oracle tables in alphabetical order (again)
#2

Peter:

There is a parameter change that you have to make, and if I remember correctly, it will not have an effect on an existing universe, so once you make the change you may need to restart your universe. But that may or may not be true.

Anyway, the parameter change is in your oracle.sbo file. There is a line that looks like this:

ColSort=3

Change it to 13, and you’ll see the columns imported in database order rather than alpha order. I don’t remember how or where I learned this, but it works. 8)

Dave

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

#3

Please, take a look at this thread: Order of Columns in Designer insists on Alphabetical

Andreas :de: (BOB member since 2002-06-20)

#4

Hi Dave,
an Oracle.sbo file…amazing, how do you guys find out things like this? I laughed when I saw the name…I thought with the struggle I have had to do this maybe it should be the oracle.sob file :wink:

Best Regards

peternolan9 (BOB member since 2003-02-01)

#5

Look at the Online Guide from BusObjects “Oracle51en.pdf”, page 117 :slight_smile:

Andreas :de: (BOB member since 2002-06-20)

#6

We find 'em out here :mrgreen: and now you do too!

Welcome to Bob :mrgreen:

Cindy Clayton :us: (BOB member since 2002-06-11)

#7

Hi…

I created a universe with option ColSort=3 .
Later I realised that I want to change the table colums as displayed in the db order so I changed the option ColSort=13 in *.sbo file, If I want to see this change in my universe ( column sort)… what do I need to do?

( I tried refresh)…

Any idea how to implement this in already developed universe.???

Thanks,
Vijay

vijaykollu :us: (BOB member since 2003-05-08)

#8

You can’t really do it. You’d have to delete the table and add it again. Even then, I’m not sure it does it.

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

#9

Looks like another item for the Wish List . . .

sunspot :us: (BOB member since 2003-03-12)

#10

Yes, a delete and re-add works. Actually, if you just rename the table to something valid, do a refresh structure, rename again back to the original, and another refresh structure, that works as well. I don’t think the joins survive (you’d have to test that yourself), so the delete and re-add is probably just as good.

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

#11

They don’t. :?

Dave

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

#12

I am trying to put the columns in alphabetical order. I put ColSort=3 in the OLEDB.SBO file. No change. I tried deleting and readding the table, no change. I tried creating a new universe, no change. I even tried rebooting and retrying everything, no change. So, what have I missed?

Lee Drake :us: (BOB member since 2002-08-15)

#13

Lee: The only time I have ever used this feature is in Oracle. It may very well be that it is not supported for other databases. Best advice is to check the database guide for your specific database… I think that there is an entire section devoted to detailing the various options from the PRM and SBO file.

Dave

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

#14

It appears to only be useful for Oracle and Informix.

From the documentation:

Description
Specifies in which order the columns are displayed in the table browser of DESIGNER.

Possible Values
3 Columns are sorted in alphabetical order. This is the default value on Oracle.
2, 3, 7 Columns are sorted by column type. This is the default value on Informix.
13 Columns appear in the order in which they were created (i.e. ODBC behavior).

Comments
You can find the parameter in the informix.sbo file and the oracle.sbo file.

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

#15

Dave, Steve,

That is what I read too. However, I read it in the MicrosoftSQLServer51en.pdf Appendix B. Since it was in the SQL Server manual, I thought that it would apply. However the manual applies to both ODBC and OLEDB, so it may work in ODBC and not in OLEDB. OR BusinessObjects may have just copied the Appendix to all the manuals without denoting which commands are supported for a given DB. :roll_eyes:

Oh, well, it is a “woulda been nice” thing. The objects in our universes are alphabetical. The Business Expert doesn’t like the database order of objects, but doesn’t have time to help me come up with an alternative. I will just continue moving them by hand.

Lee Drake :us: (BOB member since 2002-08-15)

#16

Maybe I am missing something here but I thought that when you are in Designer, all you had to do was to go to tools …options… and checkbox whether you wanted in alpha order or DB order. I know that bites me every once in awhile when I reinstall Desinger and by default the option is set to alpha. HTH

scott copeland (BOB member since 2002-08-15)

#17

Maybe, I am missing it Scott but I do not see that option in BO Designer, menu Tools| Options… :crazy_face:

Andreas :de: (BOB member since 2002-06-20)

#18

sorry Andreas - I’m home right now; maybe it wasn’t in Options. I’ll check in the morning but I know I had to “relearn” that a couple weeks ago and that seemed like the place. I do remember I had trouble finding where.

scott copeland (BOB member since 2002-08-15)

#19

It’s not in Designer. It’s in the SBO file.

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

#20

sorry I was way way off :oops:
what I changed is a setting inside the middleware I use.

but it should be in Designer :roll_eyes:

scott copeland (BOB member since 2002-08-15)