asked on November 22, 2021
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"
}
⋅ November 22, 2021
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
