Sorting dimensions

[Sébastien Le Bail]

Hi all,

I'm new on Cubes and OLAP (but I successfully installed Cubes and configured a model to analyse my data). Everything is working fine and my data are properly display and filtered when using CubesViewer to view the data.

I've just only one problem : I can't figure out how to sort the dimensions to display the chart in a way that the X axis is sorted (this is very problematic for dates !). I'm fighting with this issue since 3 days and still can't find how to sort dimensions.

This is how I defined the 'depdate3' dimension in my model :

{

"name": "depdate3",

"label": "Departure date",

"info": {

"cv-datefilter": true,

"cv-datefilter-hierarchy": "daily"

},

"role": "time",

"levels": [

{ "name": "dep_year", "label": "Dep Year", "role": "year", "label_attribute": "year", "key": "year", "attributes": ["year"]},

{ "name": "dep_month", "label": "Dep Month", "role": "month", "label_attribute": "month", "key": "month", "attributes": ["month"]},

{ "name": "dep_day", "label": "Dep Day", "role": "day", "label_attribute": "day", "key": "day", "attributes": ["day"]}

],

"hierarchies": [

{

"name": "daily",

"label": "Daily",

"levels": [ "dep_year", "dep_month", "dep_day"]

}

]

}

Columns in DB (postgres) of table depdate3 are  :

id_dep_date ; year ; month ; day

2016-10-13  ; 2016 ; 10    ; 13

2016-10-14  ; 2016 ; 10    ; 14

2016-08-28  ; 2016 ; 8     ; 28

...

...

The cube is referencing the depdate3  table with :

...

"dimensions": [..., "depdate3", ...]

...

"joins":[

            {"master": "bikerides3.id_dep_date", "detail": "depdate3.id_dep_date"},

                 ...

]

...

When display a bar chart with 'Departure Date/Dep Day' as horizontal dimension bar are ordered like this :

2016/10/13    2016/10/20   2016/10/15   ...   2016/10/14  ...   2016/8/28...

Any idea to help me ?

Thanks a lot,

        Seb

[Boris Tseytlin]

Facing the same problem!