FlexGrid - Date cubes as column labels in pivot mode and automatic time-grouping

Domenico Panetta

Hello,

currently FlexGrid does not recognize date cubes when they are used as column labels in pivot mode.

This is a date cube (column "Input Date") in flat mode and it is fine:

This is the same date cube used as a column label in pivot mode:

Even if it is a 'date', it is not recognised as a date and has no native temporal groupings (like time entities that can be grouped by week, month…).

The proposal is to develop an automatic decoding of data type columns (not only time entity but also cube data) so that time groupings are natively available as in Excel's pivots: