Skip to main content
S
Siva_Mudhigolam
September 14, 2023

data seed from One Scenario to another Scenario

  • September 14, 2023
  • 1 reply
  • 0 views

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

B
Big_Rick_CPM
September 14, 2023

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

Terms & ConditionsAccessibility statement