We have integrated Mondrian (Version: 18.104.22.16844) and JPivot for our client application and our client requires to expand all dimensions (X axis and Y Axis) and then generates Excel report for expanded view. Generally they have to click on "+" for each node to expand.
My question is: Is there any option or feature to expand all nodes at the same time?
Also we noticed that when we click on "+" to expand the node, it sends the request to server and refreshes the view with expanded node.
My Question is: Is there any option or any suggestions to implement this through AJAX so the request is made seemlessly without page refresh?