on 10-07-2013 8:42 PM
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?
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.