Date formatting options for AAS

Answered
Nil 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"
}
 

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Please login or Register to Submit Answer