If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Sort Order

Started by rams143, 30 Jun 2010 11:08:42 AM

Previous topic - Next topic

rams143

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??????

blom0344

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..

rams143

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?

blom0344

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)