How can I influence the order of the fields in the navigation area? I would like to put them in a logical order. In this case the user hase first to select a Template, then a NodeNumer and Then a ProfitcenterNode.
Hack I used is put some spaces at the beginning of the Dimension or measure name
dimension: profitcentertemplate {
label: " Profitcenter Template" #used 2 spaces to change order
group_label: "ABC"
description: "XYZ"
type: number
sql: ${TABLE}.aaa ;;
}
dimension: nodenumber {
label: " Node Number"
;;;;;;;;;;
}
dimension: profitcenternode {
label: "Profitcenter Node"
;;;;;;
}
Hack I used is put some spaces at the beginning of the Dimension or measure name
dimension: profitcentertemplate {
label: " Profitcenter Template" #used 2 spaces to change order
group_label: "ABC"
description: "XYZ"
type: number
sql: ${TABLE}.aaa ;;
}
dimension: nodenumber {
label: " Node Number"
;;;;;;;;;;
}
dimension: profitcenternode {
label: "Profitcenter Node"
;;;;;;
}
yes, but it’s a workarround, not a right solution. When i have a long dimension, i will get crazy to sort with spaces :):)