We have a data form with below design:
POV: version dimension (Finance member) & Currency dimension (local member)
PAGE: Idescendants(Entity), Idescendants(Accounts), Idescendants(YearTotal), Idescendants(Business Units), Idescendants(Products)
COLUMN: Years (FY19), Scenario (Actual), Analysis(Total Revenue)
ROW: Idescendants(Location)
Now whenever I select all the parent members in the PAGE, the form is taking around 5 mins to refresh. Kindly suggest to enhance the performance.
NOTE: There is no data loaded yet and there is no Business rule on the form.
Below are my dimensions:
