Not Able To Write Custom Calculations On Movement (Doc ID 2424832.1)

Last updated on FEBRUARY 07, 2023

Applies to:

Goal

Problem description -
----------------------------

The requirement is to create a calculation for Movement members that will create the necessary blocks while minimizing a performance impact that is expected from creating movement dimension member formulas which is not suggested best practice..

Below is the rule which takes a very long time to run consol. It is evident that putting a large set of dense member (account) in Fix and using a sparse block member are the reasons for poor performance.



/*code starts*/

FIX( @REMOVE(@relative("FCCS_TotalInputAndAdjusted",0),"FCCS_JOURNAL INPUT"),@relative("FCCS_Intercompany Top",0) ,@RELATIVE("Total Custom2",0),@RELATIVE("Total Custom1",0) )

FIX((@REMOVE(@RELATIVE("FCCS_Balance Sheet",0), @LIST("FCCS_BALANCE", "FCCS_CTA"))) )
  
  "Mvmts_MVT_CALC"
  (
  
  
"Mvmts_MVT_CALC"="FCCS_ClosingBalance_Input"-"FCCS_TotalOpeningBalance"-"FCCS_Mvmts_Cash"-"FCCS_Mvmts_Operating"-"FCCS_Mvmts_Investing"-"FCCS_Mvmts_Financing"-"Mvmts_FXINPUT";
  
  
  )

ENDFIX
ENDFIX

/*Code Ends*/
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.