PBCS form performance issue

Hi Everyone,

We are seeing performance issue in our forms which take more than 2 minutes to load 1000 rows where form is built on the out of the box financials cube(OEP_FS) with 3 custom dimensions and Product dimension enabled.

Our form layout is as below:

Rows: Account(Dense), Analysis(Sparse), Function(Sparse), Vertical(Sparse) -> all level 0 stored members

Columns: PlanElement(Sparse), Scenario(Sparse), Version(Sparse), Years(Sparse), Period(Dense) -> all level 0 stored members except for period and PlanElement( with dynamic calc members YearTotal from Period, Total Plan from PlanElement)

Page/POV: Entity(Sparse), Currency(Sparse), ManagementOrg(Sparse), Product(Sparse) ->All level 0 stored members