cancel
Showing results for 
Search instead for 
Did you mean: 

Sorting Month

former_member539471
Participant
0 Kudos

Hello All,

How do I sort an object month (JAN - FEB) in Universe since I have to use this is query filter.

Thanks in advance....

Regards...

Accepted Solutions (1)

Accepted Solutions (1)

former_member203850
Contributor
0 Kudos

See below links for the same :

Regards,

Pranay

Answers (2)

Answers (2)

vaibhav_rathore
Participant
0 Kudos

Hi,

Sorting manually in webi or managing lov's in IDT will work.

Regards

Vaibhav

former_member539471
Participant
0 Kudos

How can Sort manually in IDT. I looked for options and i did not find any?

vaibhav_rathore
Participant
0 Kudos

Hi Pali,

In IDT you can perform the following basic steps to insert manual sorting Month wise:

1. In a business Layer go to Parameters and LOV's

2. Select LOV based on Business layer Objects, and name the LOV.

3. Open Edit query panel and include the object that you want to sort.

4. Activate the sort option and select Ascend or Descend.

5. Go back to Business Layer and make a copy of the object to be sorted and associate the customised LOV to it.

6. Save it and publish it.

Former Member
0 Kudos

Hi Pali,

We can put FORCED_SORTED_LOV parameter to Yes in order to ensure sorted LOVs at prompt level; however, in your case, April will come first as the object values will be treated as String and NOT Months.

Do you have any object to capture Month Number? If yes, concatenate it with Month Name and create a new object at universe level as:

[Month] = [Month_number] + [Month_name] and use it in prompt.

With this, you will be able to sort the values properly as sorting will be done as per month number now and not month name

Hope it will help.

Regards,

Yuvraj