Expanall is very slow in Pivot Table

I have OLAP cube connected to flex monster pivot Table. It is working fine.
I kept 7 dimensions and 1 Measure. After loading the table, i have clicked on the ExpandAll button.
It is taking lot of time to exand the data.(i.,e more than 45 minutes).
Is there any way to make this operation very fast.
Thanks in advance.

1 answer

Tanya Gryshko Flexmonster September 13, 2018

Thank you for writing to us.
First of all, please specify the connection to your OLAP cube. Is it Flexmonster Accelerator or XMLA? Flexmonster Accelerator is capable of way faster data transferring than the XMLA protocol.
Also, the speed of ExpandAll operation depends on the size of your data. When you run this operation, it starts to expand all nodes in your dataset. With 7 dimensions selected, there can be a huge number of rows. Maybe not all the dimensions are necessary at a time.
One more thing to check is your server performance, i.e. how fast are the responses from the server.
Hope the above suggestions will be useful. Please share your feedback with us.

This question is now closed