Calculation script executing more time

Summary

Calculation script executing more time

Content

Hi Team,

I'm facing Perfromance issue ,while executing calculation scripts and please guide us and Thanks in advance.

We have 13 Dimension(Account&Period are Dense and Remaining dimensions are Sparse) and below are the member details.

   

From this line,when am taking the inter section  "P_Dim_Total"->"B_Dim_Total"->"S_Dim_Total"->"CC_Dim_Total" have problem. If am taking P0000 instead of  P_Dim_Total ("P0000"->"B_Dim_Total"->"S_Dim_Total"->"CC_Dim_Total" ) working faster.

Scripts as:

========================

SET UPDATECALC OFF;

SET AGGMISSG OFF;