cancel
Showing results for 
Search instead for 
Did you mean: 

Sorting period in Universe Designer?

Former Member
0 Kudos

Hi Experts,

I have a universe which contains previous six months data.

PeriodValue2
12/201430
01/201520
04/201550
02/201570
11/201425
03/201510

I am unable sort this in universe level. i want get result like below.

PeriodValue2
11/201425
12/201430
01/201520
02/201570
03/201410
04/201550

Please help me on this.

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member

why do you want to sort it on universe level?

You can do it on WEBI report!

Is this your specific requirement?If yes then you can do it using custom LOV option in universe.

In Custom LOV:

You can create LOV using SQL query,so all you need to do is just write down SQL query which will fetch the columns required by you (Period & Value2 from table) & in last apply order by clause like

Order by Period.

Which will give you sorted output.BTW I didn't understand your sort order in above example given by you.

So please explain it clearly.

Thanks,

Swapnil

Former Member
0 Kudos

Hi Swapnil,

very simple. i am IDT and developing dashboards using Design Studio. So, for me data coming from data base like zigzag manner. now i want to sort it in Universe level and pass it to design studio. i am not using WEBI at all.

So please let me know if we can do sorting in Universe level.

Thanks

Former Member
0 Kudos

If you want to apply sorting on universe then you have to create derived table.

Where as in derived table you can write down SQL with order by clause like

select period , value2 from

table_name

order by 1 desc

Now create objects for this derived table & drag the objects on universe,you will get you desired output.

Thanks,

Swapnil