BusinessObjects Board

6.5.1 Column order in the structure view

building semantic layer
#1

I’m creating a new universe with 6.5.1 and I can’t turn off having alphabetically sorted columns in the structure view.

With older versions you had the “ColSort=13” entry in the oacle.sbo file. With 6.5.1 this legacy stuff is done away with and your given the COLUMNS_SORT value in your Universe Parameters.

According to the help file the parameter’s default value of “No” should not be sorting. However, COLUMNS_SORT isn’t doing anything for me being set to either Yes or No.

Any ideas?

nathanebht :us: (BOB member since 2004-02-05)

#2

The problem may be that the tables are already there. The setting won’t change tables that already exist in the universe.

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

#3

Nope, like I said its a brand new universe. Our database is Oracle 9.2. I’m hoping someone else with 6.5.1 can duplicate this bug.

nathanebht :us: (BOB member since 2004-02-05)

#4

Rather than waiting for someone else to duplicate the bug – if it happens to you consistently, you should open a case with tech support, and let them classify it as a bug.

Anita Craig :us: (BOB member since 2002-06-17)

#5

Refreshing the structure will change the sorting in existing tables as well.

anorak :uk: (BOB member since 2002-09-13)

#6

Really? Now that would be most useful! I’ve had to revert to stuff like this in the past to get things to re-sort.

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

#7

Dwayne,

After my post yesterday I discovered that refreshing the structure only changes the column sort order if there are other changes to the structure to be made as well. It doesn’t work if there are no structure changes.

anorak :uk: (BOB member since 2002-09-13)

#8

That now describes the behavior I have seen in past versions. Not surprised that it is unchanged. If you look at the code snippet I referenced earlier, you’ll see that’s essentially what it does … changes the structure ever so slightly, so that the refresh triggers the re-sort.

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

#9

Has anyone been able have the 6.5.1 Designer NOT display a table’s fields in alphabetical order? We’re using Oracle 9.2.

nathanebht :us: (BOB member since 2004-02-05)

#10

For Oracle databases, I have not been able to make the Columns_sort parameter make any difference. It always sorts alphabetically; even when I don’t want it to. For other databases is seems to work fine.

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

#11

Just in case someone is looking for the same information… It works if the universe connection uses Oracle ODBC driver and not the direct Oracle Driver… It doesn’t work if we use the normal Direct Oracle Driver…

Sridharan :india: (BOB member since 2002-11-08)