Expanall is very slow in Pivot Table

Hi,
 
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

Public
Tanya Gryshko Flexmonster September 13, 2018

Hello,
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.
Regards,
Tanya

This question is now closed