Sort (order) By in Framework Manager

[rrahmani]

Hi there,
Is anyone aware where (if at all) you could set Sort (Order) By in FM, perhaps in the properties of a data item?
For example how to achieve Sort on column City, By another column?
Cheers
Ramin

[MFGF]

Hi there,
Is anyone aware where (if at all) you could set Sort (Order) By in FM, perhaps in the properties of a data item?
For example how to achieve Sort on column City, By another column?
Cheers
Ramin

Hi,

If you are creating a Regular Dimension object, you can specify sorting on the Members Sort tab - but this will be for all levels of the hierarchy. If you are referring to a relational data item, you can't specify sorting in FM.

Cheers!

MF.

[rrahmani]

Thank you for the reply. Yes agreed on the dimensional, we were hoping it was possible for relational too where an automatic ORDER BY is added to the SQL. Not too worry.
Cheers
Ramin