on 10-20-2014 8:00 PM
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Sorting manually in webi or managing lov's in IDT will work.
Regards
Vaibhav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.