Skip to Content
0
Former Member
Jun 06, 2011 at 06:02 PM

LOV Sort in Universe

162 Views

Hi,

We have a Variable created in BEx Query for Calender Year/Month and also List of Values (LOV) object come from the Bex Query to the Universe

LOV is working finr, but default the values are in ascending order. Do we have any solution or approach to get these list of values in descedning order. I am looking for some tricks in Universe or in Bex query. I am aware to sort this in Web I reports.

Currently, we get - 2001001, 2001002... 2011001, 2011002..

We expect as - 2011002, 2011001, 2010012, ....., 2001002, 2001001.

Any suggestions.

Thanks in advance.

Jai