☝️Small business or a startup? See if you qualify for our special offer.
+

Issue with select request of type "drilldown" in custom data source pivot

Answered
sedApta 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

Attachments:
expandRows_.zip

5 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster 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

Public
sedApta 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:

  1. Pivot opens without the hierarchical field "Date" expanded, even if the slice is configured to expand all fields.
  2. You can reproduce a similar issue of the original ticket by expanding the year 2023: the cells of the Climate level are empty.

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

Public
Maksym Diachenko Maksym Diachenko Flexmonster 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

Public
Maksym Diachenko Maksym Diachenko Flexmonster 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

Public
Maksym Diachenko Maksym Diachenko Flexmonster 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

Please login or Register to Submit Answer