Need a special offer?Find out if your project fits.

FDS Date Hierarchy Display & Sorting

LittleMan asked on May 17, 2023

Hi Team,
I'm trying to get a hierarchy configured in FDS and have a couple of issues.
When displaying the data in a form, the date (day) column shows without formatting to the correct date format. Only certain dates are formatted correctly. All data is in the correct format of 'YYYY-MM-DD'. This display issue does not occur for all records.
This is causing the sort order of the data to behave erratically due to the display of the data not using the assigned format.
The attached screenshots show the FDS Mapping, field filter selection and the display.
Slice is defined as
{"rows":[{"uniqueName":"Date Price"}],"columns":[{"uniqueName":"[Measures]"}],"measures":[{"uniqueName":"RB","aggregation":"count","grandTotalCaption":"Book"}],"drills":{"rows":[{"tuple":["date price.[2019]"]}]}}
Mapping is as below for the date hierarchy.
"DPyr":{"type":"number","hierarchy":"Date Price","dimensionUniqueName":"Dates","caption":"Year"},"DPmth":{"type":"string","hierarchy":"Date Price","dimensionUniqueName":"Dates","caption":"Month","parent":"DPyr"},"DP":{"type":"date string","hierarchy":"Date Price","dimensionUniqueName":"Dates","caption":"Day","parent":"DPmth"}

1 answer

Nadia Khodakivska Nadia Khodakivska Flexmonster May 18, 2023


Thank you for reporting the issue.

We will take a look at the described behavior and provide a fix with our minor release with the ETA June 26th. Our team will notify you about the release.
As a temporary workaround, you can set the "type" of the "DPyr" field as a "string". This way, the dates will be shown correctly. 

You are welcome to contact us in case further questions arise.

Kind regards,

Please login or Register to Submit Answer