asked on January 21, 2025
Hi,
I found an issue on 'select' of type "drilldown "requests. Attached a sample to reproduce the issue.
Exact steps to reproduce the issue:
1. expand year 2023
2. cells for Climate level are empty
3. notice the 'select' request
4. Climate field is missing in rows
I would like to point out that if 2023 is collapsed and then expanded again, the cells remain empty. However, if the same action is performed on the row item, the cells are filled correctly. Could you please fix this issue?
Thanks in advance
Fabio
⋅ January 22, 2025
Hello, Fabio!
Thank you for reporting this issue.
We appreciate your effort in providing a detailed description and sample project. This behavior is reproducible on our side and is likely caused by Flexmonster sending incorrect "/select" requests when drills are combined with expands set via expandAllRows property. Our developers will investigate this case and provide a fix in one of the upcoming minor releases, ETA Feb 17th.
As a temporary workaround, we suggest directly defining the tuples that should be expanded in the following way:
"rows": [{
"tuple": ["Continent.[Asia]"]
}]
Please let us know if this would work for you.
Best Regards,
Maksym
⋅ January 24, 2025
Hello!,
we've found another case similar to this one: changing the slice with the following code:
"slice": {
"rows": [
{
"uniqueName": "Continent"
},
{
"uniqueName": "Climate"
}
],
"columns": [
{
"uniqueName": "Date"
},
{
"uniqueName": "[Measures]"
}
],
"measures": [
{
"uniqueName": "Quantity"
}
],
"expands": {
"expandAll": true
}
}
we have two issues:
So the issue seems related not only to "expandAllRows" but also to "expandAll". We didn't investigate yet on "expandAllColumns" but please make sure that also this method hasn't this issue.
Thanks
Fabio
⋅ January 27, 2025
Hello,
Thank you for reaching out to us.
For the first issue, we would like to mention that the expands object controls data visibility by expanding or collapsing different hierarchy levels. In contrast, the drills object tracks drill-down actions within multilevel hierarchies. Hence, the described behavior when drills are not performed with expandAll is expected. To ensure that both drills and expands are performed, you should also enable the drillAll property, as is shown in this example: https://jsfiddle.net/flexmonster/eo9q7c8v/
Regarding the second issue you mentioned, our team will review similar combinations of drills and expands and fix any found bugs related to your original inquiry. This includes the issue with drills and expandAll which you reported.
Please let us know if more questions arise.
Best Regards,
Maksym
⋅ February 4, 2025
Hello,
We are happy to inform you that the issue with data in expanded cells being missing when there are drills in the slice and expandAllRows, expandAllColumns, or expandAll property is set to true was fixed. This is included in the 2.9.96 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-96/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please tell us if the fix works.
Best Regards,
Maksym
⋅ February 18, 2025
Hello,
Hope you are doing well.
We are wondering if you had time to test the fixes for expandAllRows, expandAllColumns, or expandAll properties.
Please let us know if they worked for you.
Best Regards,
Maksym