data seed from One Scenario to another Scenario

Siva_Mudhigolam
New Contributor II

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)

1 REPLY 1

Big_Rick_CPM
Contributor

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'.