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"}
Hello,
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,
Nadia
Hello,
We are happy to let you know that the issue with hierarchy levels that have different data types set in the mapping was fixed.
This is provided in the 2.9.54 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-54/
You are welcome to update the component. Here is our guide on upgrading to the latest version: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if the fix works fine for you.
Best Regards,
Maksym
Hello,
Hope you are doing well.
We were wondering if you had a chance to test the updated version. Could you please confirm if the fix works well for you?
Looking forward to hearing your feedback.
Kind regards,
Nadia
Hello,
Hope you're doing well.
Just checking in to ask if you had the opportunity to try out the latest version. Can you please let us know if the issue has been resolved?
Looking forward to hearing from you.
Best regards,
Nadia