Forum Discussion

Siva_Mudhigolam's avatar
Siva_Mudhigolam
New Contributor II
2 years ago

data seed from One Scenario to another Scenario

Hi All,

I want to seed the data from below source, please help me how to write a code for the below data copy.

Target:-

api.Data.Calculate("V#PERIODIC:O#Import:U3#" & UD3 & ":U8#UND_UD8:U4#" & CurrWk & "=

Source:-

RemoveZeros(S#Actual:U4#TOP:T#" & Priortime & " - S#Weekly_Processes:U4#Week_1:T#" & Priortime & " - S#Weekly_Processes:U4#Week_2:T#" & Priortime & " - S#Weekly_Processes:U4#Week_3:T#" & Priortime & " - S#Weekly_Processes:U4#Week_4:T#" & Priortime & ")","A#KPI_PPV_MONTHLY,A#KPI_TOT_PURCH_DPO",,,,,,,,,,,"U8#Top",,,True)

Finance
  • Big_Rick_CPM's avatar
    Big_Rick_CPM
    Contributor
    2 years ago

    When trying to set account type dimensions (e.g. the UD's) on the left hand side of the equation dynamically, you are going to need to look into using unbalanced math functions or creating a data buffer and setting calculated cells into the buffer. 

    I highly recommend the 'OneStream Finance Rules and Calculations Handbook'.