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

posted on January 21st, 2025

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

3 answers

Public

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 ⋅ 6 days ago

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:

Pivot opens without the hierarchical field "Date" expanded, even if the slice is configured to expand all fields.
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 ⋅ Flexmonster ⋅ 3 days ago

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

Changes to Flexmonster Software License Agreement

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

3 answers

Please login or Register to Submit Answer