Looking for some ideas on how to speed up the rendering time of element expansions (clicking + / - on rows). After removing styling and accounting for the MDX query time, the rendering is still quite long. MDX requests complete, then a few seconds later the expansion renders.
#1 is removing excess columns. In terms of rendering time columns are much, much more expensive than rows.
We don’t have a lot of flexibility on columns based on the business requirements, but I will keep that in mind.
In one of our case, the client was complaining about too many clicks and slowness. We have done mdx subset based on a user selection.
1 Like
Is drilling/collapsing based on filters an option?
If so you could add an extra filter (Max Depth) and update your mdx accordingly.
Good idea, but this isn’t a depth issue. Most consolidations have no more than 5-10 children.
Yes but this allows less clicks and arguably better performance comparing to hitting +/- buttons to collapse and expand.