Print Page - Sorting on Members

Title: Sorting on Members
Post by: Sarayucog on 04 Mar 2011 03:05:07 AM

Hi All,

I have list report and using DMR package. In list report how to apply sorting on a member.

I know how to apply from the tool bar. I want to know is there any other way to apply the sorting on the member.

Thanks in advance

Title: Re: Sorting on Members
Post by: rockytopmark on 04 Mar 2011 11:37:35 AM

Use the order() function

Title: Re: Sorting on Members
Post by: Sarayucog on 05 Mar 2011 04:46:38 AM

Thakns for your reply.

I forgot to inform you that I have tried with Order() and Hirarchize() functions also. These two functions are also not suitable to my scenario.

Please let me know if any other things you know.

Title: Re: Sorting on Members
Post by: JGirl on 05 Mar 2011 07:29:34 PM

If you are using a 'Set Expression' in your query, you can specify set sorting (a property of the data item).

Your options are ascending, descending, hierarchized, and you can sort by a caption, a property (another data item such as an attribute), or a tuple.

Title: Re: Sorting on Members
Post by: AussiePete2011 on 06 Mar 2011 05:19:55 PM

Hi there

Check this document out
http://www.ibm.com/developerworks/data/library/cognos/page364.html

Also for dimensional reporting check out the available functions
http://www.ibm.com/developerworks/data/library/cognos/page82.html

Cheers
Peter B

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Sarayucog on 04 Mar 2011 03:05:07 AM