Sorting of column tips required

[Rajasekaran T]

Hi All

I am new to cognos framework, I am trying to sort company Heirarchy based on column. I.e I have column called "Designation" and another column called "Designation_Sortorder". How can I include this sort at framework level so that when ever the dimension "Designation" is used its sorted??

Rajasekaran T

[Lynn]

There is no sort property for relational metadata as far as I know. Sorting is accomplished on the reporting side. Default sorting in this scenario is largely dictated by the database through the SQL that is generated and the indexes hit.

In a dimensional model you can specify the sort order for members in a level: http://pic.dhe.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_fm.10.1.0.doc%2Fug_fm_id7264sort_members_level.html