Trying to copy data from Account and Movement dimension
We are trying to copy data from :FCCS_Retained Earnings ->FCCS_TotalOpeningBalance to Account SOCIERE->STATMVMT_OpBal using the below script but the script is in process for more than 45 minutes .any help to improve the performance.
NOTE : Period and Movement are dense dimensions.
NoAnalysis is custom 2 dimension and is used to open the block.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
FIX("FCCS_Data Input","No CostCentre","FCCS_Periodic","No Departments","FCCS_No Intercompany")
IF("Retained Earnings"->"FCCS_TotalOpeningBalance"->"FCCS_TotalInputAndAdjusted"->"Total CostCentre"->"Total Departments"->"FCCS_Intercompany Top"<>#missing)