We are facing performance issue in DSO application
Summary:
We are facing performance issue in DSO application. Force Translation (By Selected View) has been taken 4 hours for one period however non DSO was took 35 minutes . But Predict Consol rule job log saying consolidation will take 23 minutes.
Log messages :
System Predicted Time To Complete The Job : 23 minutes 8 seconds
CONSOLIDATION SCOPE :
Entities to be consolidated : 489
Periods to be consolidated : 1
APPLICATION CUSTOMIZATION STATISTICS :
EPU sequence : No
Calculate Movements : No
Ratios : No
Deployed Configurable Consolidation Rules : 20
Deployed Translation Override Rules : 2
Deployed Insertion Rules : 3
DSO : Enabled
DATABASE PROPERTIES :
Total Dimensions : 15
Standard Dimensions : 15
Dense : 2.0
Block Size Cells : 5222.0
Block Size KB : 40.0
Level 0 Blocks : 6748792.0
Upper Level Blocks : 16201211