cancel
Showing results for 
Search instead for 
Did you mean: 

How pre-sort items in queries?

cgwaters
Participant
0 Kudos

On Page 56 of the "SAP BusinessObjects Business Intelligence Suite 4.0 Support Package 5" PDF, it says: "Click Sort on the Result Objects toolbar and use the "Sort" dialog box to sort the query result." I can't find that item in Web Intelligence--neither the web client nor the Rich Client.

I want to presort the items that appear in my queries--rather than have the user see an unsorted list and have to manually sort it. How can I accomplish that?

Accepted Solutions (0)

Answers (5)

Answers (5)

cgwaters
Participant
0 Kudos

I think I've resolved this.

Within the IDT, I created a List of Values object for each of prompts that are on the "Prompts" dialog box in my WebI report. For each LoV, I specified that the results are to be sorted on the appropriate column, and then I associated that LoV with the corresponding business layer object; i.e., each of the objects that are prompted for within my WebI report.

Now within WebI, the values in each of the prompts is sorted properly.

So, for each prompt, rather than WebI simply going out to that object's data source, retrieving the list of values, and displaying them in natural (i.e., unsorted) order, WebI is using that prompt's object's List of Values (which returns the values, sorted). That enables WebI to to display the values in sorted order.

This seems like a lot of extra effort -- but at least it works!

Former Member
0 Kudos

Hello Chris,

did you already tried using the FORCE_SORT_LOV Flag in the business layer (+DF)?:

Best regards,

Victor

Former Member
0 Kudos

hello Chris,

We have a query with 10 objects and we want that the query order by one of this field, this object not is in "filters query".

Could you explain us how you did it?

Thank you.


cgwaters
Participant
0 Kudos

Thanks, everyone. I'm referring to when the report is opened and the "Prompts" dialog appears. For each prompt, the user can select the value(s) from that prompt's query; however, the items in that query/list are not sorted. The user can press the column heading to sort the list; however, I want the list to be pre-sorted (ascending).

My apologies, the first portion of the PDF I referred to did not include the product name. I meant to say: "SAP BusinessObjects Web Intelligence Users Guide - SAP BusinessObjects Business Intelligence Suite 4.0 Support Package 5". Page 56 of that document refers to a Sort button on the Results Objects toolbar on the Query Panel dialog box. That button does not appear in my WebI clients.

Former Member
0 Kudos

Hi Chris,

You are right I can not see any buttons to sort the objects in query panel even though its mentioned in user guide.

However in a webi report vertical table there is a default sort of the objects from left to right.

Former Member
0 Kudos

Mishra,

I see the same issue - there is no Sort button on the Result Objects toolbar on the Query Panel even though this IS mentioned in the User Guide.

It seems the correct solution is not finding a work-around, but making what should be there actually be there.

Former Member
0 Kudos

Chris,

When you say that users see an unsorted list, whereabouts do you mean?

The default sort for Webi reports has always been by columns (left-to right - column 1 ascending, column 2 ascending, etc.)

Are you suggesting that this has changed in BO4?

Former Member
0 Kudos

Hi,

You can sort the query's result objects while building your query in Dashboard.

PFB Screenshot:

Thanks.

Former Member
0 Kudos

Please explain your requirement a little more ; are you trying to sort a object from IDT or a webi report.

Also please include the link of the document you are referring to.

If you are trying to sort the data in a report based on a object you can just right click on that object in the webi design mode and select the sort type Ascending / Desc or Custom.