Imporve expandAll method

Hello, György,

Thank you for reaching out to us.

Kindly note that the expandAll executing time depends on how fast the server with the cube will send a response with the data. The expansion of cells is a heavy operation, requiring many resources. It is expected to be processed slowly when performed over large data sets.
Therefore, we suggest prefiltering the data before calling the expandAll method or reducing the number of expands in the report.

We hope it helps. You are welcome to write to us in case other questions arise.

Kind regards,
Nadia

Hi, György,

Hope you are doing well.

As a follow-up, we wanted to elaborate on some points from the previous answer:

• Regarding the reducing the number of expands in the report:
  We suggest defining the expands object of the Slice when setting the report. It allows expanding not all fields but only the necessary ones. For example, you can define expands for the first few rows or columns. This will significantly increase the performance.
• Also, the expansion of all the fields is a heavy operation, requiring many resources on the machine where the Accelerator is running. We recommend checking if your machine has enough resources to execute the expandAll API call. 

You are welcome to write to us in case other questions arise.

Kind regards,
Nadia