Data form Retrieve Performance

Hi all,

I am facing a problem with a dataform. When my client opens the dataform it takes about 12 seconds to open it, for my client 12 seconds is too much because when he runs business rules on it, it takes more time due to the sum of the time of the business rule with the time of the dataform refresh.

On the rows I have the entity dimension with 22000 members.

On the columns I have 11 columns which 5 of them are column formulas. The dimensions on the column are the scenario, version, year, period and account dimension.

On the page I have the product dimension and the accountable dimension.