The '2012-01-01t00:00:00' string cannot be converted to the date type.

On a trial 
ssas connection work fine until you try to sort/filter or expand the time dimension I get the error
The ‘2012-01-01t00:00:00’ string cannot be converted to the date type.
Don’t recall this being an issue on a previous trial ?
 
Thanks
 
Ian

5 answers

Public
Dmytro Zvazhii Flexmonster November 20, 2018

Hello Ian,
Thank you for writing. The described issue is not a known one.
Could you please provide us with the example where such behavior is reproducible?
That will be very helpful in our further investigation.
Please note that you can send all the sensitive information to our e-mail.
Waiting to hear from you.
Regards,
Dmytro

Public
Ian Chapple November 20, 2018

Cant give you a live example as this all internal at the moment but here the JS code
var pivot = new Flexmonster({
 container: “pivotContainer”,
 toolbar: true,
 report: {
  dataSource: {
   dataSourceType: “microsoft analysis services”,
   /* URL to the Data Speed Accelerator */
   proxyUrl: “http://sql:50005”,
   /* Catalog name */
   catalog: “K8Sales”,
   /* Cube name */
   cube: “K8 Sales”,
   // Flag to use Data Speed Accelerator instead of XMLA protocol
   binary: true
  },
    slice: {
     “reportFilters”: [
            {
                “uniqueName”: “[Time].[Month]”,
                “filter”: {
                    “members”: [
                      “[Time].[Month].&[2018-11-01T00:00:00]”
                       
                    ]
                }
            }
        ],
    
      “rows”: [
            {
                “uniqueName”: “[Product Groups].[Lvl 2 Description]”,
                “sort”: “asc”
            }
        ],
        “columns”: [
   {
                “uniqueName”: “[Time].[Month]”
            },
            {
                “uniqueName”: “[Measures]”
            }
        ],
        “measures”: [
            {
                “uniqueName”: “[Measures].[Sales Value]”,
                “aggregation”: “none”,
                “active”: true
            }
        ]
    }
 },
 licenseKey: “xxxxxxxx”
});
 
Same issue occurs when setting the filter in the GUI

Public
Ian Chapple November 20, 2018

I think I have found what it is, the MDX on SSAS side only works when the “T” is uppercase, it seems at some point it is converted to lower.

Public
Dmytro Zvazhii Flexmonster November 20, 2018

Hello Ian,
Thank you for your feedback.
We are glad that you have managed to find the reason for such behaviour.
Still, it is not correct and we are going to fix it. Could you please provide us with the cube example where the datetime data is available?
That will definitely help us to resolve the issue.
Waiting for the update from you.
Regards,
Dmytro

Public
Ian Chapple November 21, 2018

how can I get this to you, its internal only ?
Is there something I can export ?
 
Thanks
 
Ian

Please login or Register to Submit Answer