on 07-03-2015 2:33 PM
Hi Experts,
I have a universe which contains previous six months data.
Period | Value2 |
---|---|
12/2014 | 30 |
01/2015 | 20 |
04/2015 | 50 |
02/2015 | 70 |
11/2014 | 25 |
03/2015 | 10 |
I am unable sort this in universe level. i want get result like below.
Period | Value2 |
---|---|
11/2014 | 25 |
12/2014 | 30 |
01/2015 | 20 |
02/2015 | 70 |
03/2014 | 10 |
04/2015 | 50 |
Please help me on this.
Thanks
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.