Hi Team,
We want to change the format of particular date field 2005-06-18 to 06/18/2005
Below is report we want to change "uniqueName": "[Calendar].[Date]" column format to 06/18/2005 .
Need a suggestion how to handle this .
{
"dataSource": {
"type": "microsoft analysis services",
"proxyUrl": "https://fmaccelerator.com/api/accelerator",
"catalog": "Dev",
"cube": "Model",
"binary": true
},
"slice": {
"reportFilters": [
],
"rows": [
{
"uniqueName": "[Calendar].[Date]"
}
],
"columns": [
{
"uniqueName": "[Measures]"
}
],
"measures": [
{
"uniqueName": "[Measures].[Msr]",
"caption": "Measure"
}
],
"expands": {
"expandAll": true
}
},
"options": {
"viewType": "charts",
"chart": {
"title": "Bar Chart ",
"multipleMeasures": true,
"showLegendButton": true,
"showDataLabels": true
},
"datePattern": "MM/dd/yyyy",
"dateTimePattern": "MM/dd/yyyy"
},
"version": "2.9.11",
"creationDate": "2021-11-22T05:09:54.998Z"
}
Hello, Nil,
Thank you for reaching out to us.
For Microsoft Analysis Services, Flexmonster uses date formatting configured inside the cube. It means that you will need to adjust the formatting on the SASS side.
You can learn more about the date and time formatting in our documentation: Date and time formatting.
Please let us know if it works well for you.
Kind regards,
Illia