Hi,
I am creating a data form against the oracle recommendations mentioned in oracle document 779502.1.
These are the dimensions i am using in my form:
CC = sparse dimension with members 561
RCC = sparse dimension with members 545
Period = dense dimension with members 21
Account = dense dimension with members 1986
Line Item = sparse dimension with members 621
Product = sparse dimension with members 242
This is my structure of form:
1 - CC and RCC (both sparse) used in POV with all the members
2 - Period column in column with 14 members
Product in column with 20 members
(period is dense and product is sparse)
3 - Line item in row with 6 members.
Kindly view the below image too:
The issue is, this form is taking more than 10 mins to load. I have even tried opening this form with 0 block (after clearing all data) and still it is taking more than 10 mins.
Kindly suggest what can we do to improve the form performance?
1 - Shall we change it's structure (which is not feasible for us)?
2 - Do i need to increase caches?
3 - Do we need to change evaluation order? we are using hour glass methodology at the moment.
Hyperion Planning version: 11.1.2.4.500
Web Browsers: IE and Firefox
Regards