BusinessObjects Board

Data base columns are sorted in alphabetic order in Designer

building semantic layer
#1

When we import the table structure from oracle database into designer, the columns in the tables are sorted in alphabetical order even when the value for COLUMNS_SORT parameter is set to NO in UNIVERSE PARAMETERS. We would like to see the columns in the same order as they are in the database.

This does not happen when i try to import the structure from Microsoft Access database.

Has any one faced this problem? What is the remedy for this.

We are using BO 6.5.1 and the database is Oracle 9i.

Sanjaya Doreswamy (BOB member since 2005-04-01)

#2

This is a known bug with 6.5.1 Designer. My workaround has been to use v5 of Designer to add the table (with ColSort=13 in the oracle.sbo file), then copy / paste the table into the 6.5.1 version.

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

#3

And It’s not possible to change the oracle.sbo file in v6.5.1???

I don’t have a previous BO version installed…

Do you know How can I fix it in v6.5.1?

Thanks very much!!!

mg (BOB member since 2004-01-07)

#4

If it’s a known bug – it appears you’ll need to wait for 6.5.2, or perhaps you can get a CSP (a patch) from tech support.

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

#5

Thanks every one for the response .

Sanjaya Doreswamy (BOB member since 2005-04-01)

#6

Related to this problem, this has been our experience:

In V5 our tables are sorted in database table order. We created a test repository V6.5.1 and now when a universe is imported by Designer 6.5.1, the sort order is alpha, even though the tables were table-order in the pre-upgrade repository. However, when we now export a universe using V6 Designer that was saved in version 5 it will keep the table sort order.

So why would all of the universes flip over to alpha sort order just because the universe was upgraded to V6?

Also, I find that a universe saved from the V6 repository by V6 Designer will read into V5 Designer, but it does not re-sort to table-order even though that is our default in V5.

Is there an easy way to get the universe sort order to change back to table-order by opening it in V5 Designer?

Larry Kaiser (BOB member since 2002-08-26)

#7

Yes there is … try this post.

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

#8

Thanks Dwayne, that’s very helpful.

Larry Kaiser (BOB member since 2002-08-26)