Print Page - Sort Data on DMR using orders function

Title: Sort Data on DMR using orders function
Post by: phanicrn on 14 Nov 2007 12:22:55 PM

Hi

Did any one use "Order " function to perform sort on Dimensional Data in FM.

thanks
phani

Title: Re: Sort Data on DMR using orders function
Post by: MFGF on 14 Nov 2007 12:54:02 PM

Are you having a particular problem with it?

MF.

Title: Re: Sort Data on DMR using orders function
Post by: phanicrn on 14 Nov 2007 01:07:58 PM

Yes, I have Problem, From FM model I am creating Regular Dimension. for dimension I am using Year column,
year as membercaption and business key.
month as member caption and calendar key as business key. when i create heirarchy. it doesnt sort on year..

i have gone thru some cognos kb's they suggested to use "orders" function which will be used for sorting on DMR's

but i dont know how to use..

when i look at the expresssion
orders( years, numeric expression, asc), I dont know what to mention for numeric expression..

help me guys

thanks
phani

Title: Re: Sort Data on DMR using orders function
Post by: MFGF on 14 Nov 2007 03:48:00 PM

Hi,

The order() function is used to sort a set of members into ascending or descending order based on a measure value or a tuple. For example, order([Country],tuple([Revenue],[2007],asc) would sort the country members by the revenue values for 2007. The numeric expression you are missing is a measure value or tuple.

Regards,

MF.

Title: Re: Sort Data on DMR using orders function
Post by: phanicrn on 15 Nov 2007 02:09:50 PM

Hi
I wil verify result and let you know

Thanks
phani

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: phanicrn on 14 Nov 2007 12:22:55 PM