Home » Fusion Middleware & Colab Suite » Business Intelligence » Override default ascending/descending order of data in columns (WINXP)
Override default ascending/descending order of data in columns [message #321734] Wed, 21 May 2008 03:21 Go to next message
mbhkr5
Messages: 20
Registered: October 2007
Junior Member
Hi,

I'm new to OBI. When I create a request with some field like ename by default it is showing in ascending order. But, business scenario needs data to be shown as it is stored in the database.
Re: Override default ascending/descending order of data in columns [message #321742 is a reply to message #321734] Wed, 21 May 2008 03:49 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
As far as I know that is not possible. However, if you have a column "helping" to find out the sort as it was in the database, you can use that one to sort the column(s) showing the request. In the business model, fill in that helping column as the sort order for the original column. Hope this explanation makes sense, details can be found in the manual.

[Updated on: Wed, 21 May 2008 03:49]

Report message to a moderator

Re: Override default ascending/descending order of data in columns [message #321977 is a reply to message #321734] Thu, 22 May 2008 00:23 Go to previous message
mbhkr5
Messages: 20
Registered: October 2007
Junior Member
Hi,
Thanks for the reply.
It worked, I set the primary key of that table as the sort column.
Previous Topic: OBI Scheduler?
Next Topic: Error while creating dimension with heirarchies from two different logical tables
Goto Forum:
  


Current Time: Thu Mar 28 11:13:14 CDT 2024