Performance issue on collapse and expand on c level

[Ronan Wang]

Hi Team,

There is a performance issue on the C-level collapse and expansion on the filter dropdown and grid row.

We are trying to figure out the issue, seems it is because the MDX

On the old version 2021.11
The C-level collapse and expansion, only one time,
The first time user expands the c-level and collapses the same c-level, and then the next time, the user expands/collapses, there won't MDX query.

On this version 2023.05
The C-level collapse and expansion, every time,
Seems like each time users click the c-level collapse and expansion, the system will send an MDX query

the first time expansion

the first time collapse

the second time expansion

the second time collapse

It will cause the system to need to wait for the MDX result to re-render the table.

[Ada Trajer]

Hi Ronan, these changes were made intentionally to ensure that the right hierarchy structure is displayed every time. We understand that this may have some impact on performance, but it is essential to consistently present the correct results.