Hi,
I have a VIEW in the database (oracle) and there are 2 columns say 'A' , 'A_DISPLAY_ORDER'. In the view the SQL says order by 'A_DISPLAY_ORDER'. So, I got the metadata from that view to the framework manager and tested the data it still shows me that 'A' is sorted by 'A_DISPLAY_ORDER'. I published the package to cognos connection and dragged the column 'A' in the query studio but it doesn't display in the sort order.
FYI, data in column 'A_DISPLAY_ORDER' is 1,2,3,4,5,......,33.
any thoughts??????
Applying a sort in a database view is not really very useful (unless you need an ordered subset) cause the final ordering is performed by the Cognos generated query. So perform the sorting from Cognos and you will get the desired result..
There is a requirement for me to provide the end users with default sort order for column 'A' when they built Ad-Hoc report in query studio. What changes should I do to make it work that way?
AFAIK Query Studio does not provide templates like Report Studio does.
You can create the report by sorting on the ordering column (deleting the column , but keeping the order by) and use this as a starting point for your users.
Combining the two column objects into one will probably give you the sorting by default (like 1. FIRSTAVALUE)