I am creating a Metadata layer with the Pentaho Editor for Interactive Reporting within the User Console. I am trying to use a Date dimension table and have found no way to select an alternative column to sort on.

My example is Sales Month. Obviously I don't want April, August, December etc to appear, but want to sort by Month number. Can this be done using the Metadata editor. I have been trying to search for a column attribute in the business view column but have had no luck. It is possible in the Mondrian schema workbench using the 'ordinal column' drop down. It seems like quite a basic requirement. I also have other items that I would like to sort not alphabetically.

Many thanks in advance for any help and tips,