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
Quote from: rrahmani on 18 Jul 2016 09:40:59 PM
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.
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