asked on November 20, 2018
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
⋅ 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
⋅ 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
⋅ 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.
⋅ 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
⋅ November 21, 2018
how can I get this to you, its internal only ?
Is there something I can export ?
Thanks
Ian
