asked on September 4, 2023
Good morning,
I'm having issues trying to make Flexmonster Pivot Grid recognize as date a field whose type on the cube is, in fact, date.
When trying to filter the dates, those seem to be interpreted as strings. For example, in the "preFilter.png" screen you can see the dates 26th of May 2021 (5/26/2021) and 31st of May 2021 (5/31/2021). If I then filter with a greater than the 31st of January 2022 (1/31/2022), the resulting data still shows the two dates mentioned before (see "postFilter.png").
It looks like the comparison is simply string-wise and being the month of January (1) smaller than May (5), the dates aren't filtered out, even though the year of the dates is before that of the filter.
As said before the dates on the cube are actual date fields, I have also tried to configure Flexmonster to "useOlapFormatting", but that didn't seem to fix.
How can I make it so that Flexmonster does interpret date fields as dates on the grid?
Thank you
⋅ September 5, 2023
Hello,
Thank you for reaching out to us.
Flexmonster supports using the "after" filter for dates with SSAS data sources. This filter would hide the dates before some specified date, as is shown in the example: https://jsfiddle.net/flexmonster/upowxe3n/
The possible reason for filters not working in SSAS may be that the certain date type is not supported in Flexmonster. To check this, please tell us the exact dimension type used for the date in your cube.
We are looking forward to hearing your feedback.
Best Regards,
Maksym
⋅ September 7, 2023
Hello,
the fields on the cube have the type date, as per this screen of the dimension properties I've attached (the format dd/MM/yyyy is different from the last screenshots I sent, but the wrong filtering behaviour still applies)
Thank you
⋅ September 8, 2023
Hello,
Thank you for sharing this information with us.
The date type provided on the screenshot is supported by Flexmonster. Could you please send us the backup of your cube in ABF(Analysis Services Backup) format so we can reproduce this behavior on our side? This will significantly help us to find out what causes the issue.
You can send the backup file via inbox to keep your data private.
Looking forward to hearing from you.
Best Regards,
Maksym
⋅ September 13, 2023
Hello,
I'm sorry, I didn't quite get where exaclty to send the backup. Is there an email address I should send the attachment to?
Thank you
⋅ September 13, 2023
Hello,
Thank you for the reply.
Our customer service team will reach out to you via email so that you will be able to send us your cube backup in the response.
Best Regards,
Maksym
⋅ September 14, 2023
Hello,
I have sent the backup
Thank you
⋅ September 15, 2023
Hello,
Thank you for sharing your cube backup with us.
We were able to reproduce the issue with date type on our side. Our team needs more time to research this behavior and provide a solution. We will contact you and share the results with us, ETA Mon 16th.
Feel free to contact us if further questions arise.
Best Regards,
Maksym
⋅ October 16, 2023
Hi Maksym, do you have any news?
⋅ October 16, 2023
Hello,
We are happy to let you know that the issue with recognizing the type of date hierarchies on SSAS tabular models was fixed. The fix is available in the latest version of Flexmonster Accelerator: https://www.flexmonster.com/release-notes/version-2-9-62/
You are welcome to update the Accelerator: https://www.flexmonster.com/doc/updating-to-the-latest-version/#!accelerator
Please let us know if the fix works fine for you.
Best Regards,
Maksym
⋅ October 24, 2023
Hello,
we are currently using as "middle layer" to make the OLAP data available to the grid the msmdpump.dll, not the Accelerator.
This fix works instead only while using the Accelerator, correct? Is there any way of fixing the issue by using msmdpump.dll?
Thank you
⋅ October 25, 2023
Hello,
Thank you for your reply.
Yes, the fix was added on the Accelerator's end since an additional query is necessary for determining the field data type as date.
Our team strongly recommends using Flexmonster Accelerator for connecting to Flexmonster since it optimizes the overall performance by reducing query size compared to XMLA. Also, the Accelerator supports connecting to msmdpump.dll, so you can use the Accelerator to connect Flexmonster to your msmdpump.dll.
Please let us know if using the Accelerator works for you.
Best Regards,
Maksym
⋅ November 28, 2023
Hello,
Hope you are doing well.
Our team is wondering if you consider using Flexmonster Accelerator. If so, we would like to know if using it helped you to fix the date issues.
Looking forward to hearing from you.
Best Regards,
Maksym
⋅ May 23, 2024
Hi Maksym,
We too are having problems with Date fields and SSAS Tabular with Flexmonster. We have our own XMLA proxy (similar to msmdpump.dll) which we need to support our app. We would rather not use your accelerator, how can we get Date fields to work in Flexmonster?
Using our Proxy and Excel Date fields work correctly in Excel pivot tables, so I don't see why they cannot be made to work with the standard XMLA endpoint?
Please Advise.
Thanks,
Brian
⋅ May 23, 2024
Hello, Brian!
Thank you for writing to us.
We noticed that you have submitted a separate ticket with this question. Please check our reply in that thread: https://www.flexmonster.com/question/problem-using-date-fields-with-ssas-tabular-and-an-xmla-endpoint/#answer-66045
Best Regards,
Maksym
