Sort Data on DMR using orders function

[phanicrn]

Hi

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

thanks
phani

[MFGF]

Are you having a particular problem with it?

MF.

[phanicrn]

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

[MFGF]

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.

[phanicrn]

Hi
I wil verify result and let you know

Thanks
phani