Sorting "List Of Values"

building semantic layer
1

Currently when we click on “List of Values” when running a report, the values are not sorted. Is there something in Business Object Designer we can do to cause the “List of Values” to be sorted?

The values appear to be in the sequence they were loaded into the tables.

Lee Hawkinson
American Family
E-mail: LHawkin1@AMFAM.COM
Phone (608) 249-0100 Extension 32097

Listserv Archives (BOB member since 2002-06-25)

2

You wrote:

“Currently when we click on “List of Values” when running a report, the values are not sorted. Is there something in Business Object Designer we can do to cause the “List of Values” to be sorted?”

Edit the properties of the object that has the associated list of values. On the second tab, there is a button to ‘edit’ the list of values for that object. In the LOV query, just put a sort on the object in the query results. There are alot of other options you can explore here, as well (setting up prompts in the LOV query, including additonal descriptive objects, etc)

Jason Beard
AGD Consulting

Listserv Archives (BOB member since 2002-06-25)

3

I’m trying to sort dates in descending order but the query panel functionality in designer XI does not work. Is there another way to handle this. I current have a prompt which is a list of dates and I want the most recent date first. Here is the prompt function

DW.D_TIME_DAY.DT IN @Prompt(‘PLEASE SELECT A YEAR?’,‘D’,‘Employee History\Load Audit as of Date (MM/DD/YYYY)’,MULTI,CONSTRAINT)

When I select the object to edit and click the properties tab and click the edit button, the query panel comes up and I supply the sort, save it and run it. When I export the universe and run it in webi the prompt list of dates are not in descending order.

bogirl (BOB member since 2005-09-15)

4

Do you export the LOV with the universe? Have you unchecked the “allow users to edit this LOV” checkbox?

Dave Rathbun :us: (BOB member since 2002-06-06)

5

I’m not sure but did you try deleting the .unv and .lov from the user platform? It’s possible that the old .lov is still there.

Mark Clese (BOB member since 2005-09-09)