Basic Data Sorting

[Former Member]

Hello,

I have a list of numbers in an XLF document, and I would like to sort it from least to greatest. Is this possible? It seems that the basic data sorting function from Excel does not work in Xcelsius.

[Former Member]

Hi Kenneth,

List View component has Data Sorting function on columns. If your data are in columns, try this component. Click the header of each column, data will be sorted by that column, ASC or DESC.

Thank you,

Grace Yu

QA, Xcelsius 2008

Edited by: Grace Yu on Sep 4, 2008 8:48 AM

[Former Member]

Hi Grace,

I am working with the List View component, and the sorting function does sort in ascending or descending order, but it sorts the data as text. The excel data is numeric, and when sorting ascending, a value of 112 is placed before a value of 43.

Are there any work-arounds for this? Also, is it possible to turn off the sorting of the list view?

Thanks,

Roger

[Former Member]

Hi Roger,

This sorting issue will be fixed in the coming FixPack 1 of Xcelsius. Please wait for a few days...

Thanks for your patience!

Grace Yu

QA, Xcelsius 2008

[Former Member]

There is a new add on component that provides this functionality called Dynamic Sort. You can find this in the BOBJ OnDemand store, or at centigonsolutions.com

Hope this helps.

[Former Member]

When using a query I make sure the sorting is done via a view of the the table that the query is running against.

If you are using QaaWS (Query as a Web Service) in XIR2 the above is the easiest way to get the sorting done via the database. In the universe you can add a parameter (File, Parameters) and set the END SQL parameter to say ORDER BY <column number> ASC, but this is very limiting and everytime you run a query from this unv the <column number> is going to be the target of the sort.

Now if you move to 3.0, QaaWs has a sort and Ranking buttons that will allow you to set the sort abilities in the column you wish.

[Former Member]

Hi Kenneth,

Unfortunately Xcelsius does not contain a feature that will automatically sort your excel data in runtime.

If you have a static data set:

Sort the data in Excel first, then import the spreadsheet into Xcelsius. Note: This will not automatically sort your data in runtime if your raw dataset continues to change.

If your data set changes dynamically and you need to sort in SWF runtime:

1) Use Excel logic to read your data column and then build a new column with Excel functions to have the numbers in a sorted order.

2) (If the data comes from an external source) Configure your Web Service to sort the data beforehand, so that it is already in ascending order when Xcelsius consumes that data.