Forecast Seeding not working for AdjInput
Hi,
I'm trying to copy data from Actuals into Forecast, but it seems to only work for Input and Forms Origin members, and not for Adj. Here is my formula, which I put on the Forecast Scenario:
'Copy data from Source Scenario for months 1-5
Dim currMonthNum As Integer = api.Time.GetPeriodNumFromId(api.Pov.Time.MemberId)
Dim sScenario As String
Dim ScenarioSource As String = api.Scenario.Text(api.Pov.Scenario.MemberId, 1)
If ScenarioSource = "" Then
sScenario = api.Pov.Scenario.Name
Else
sScenario = ScenarioSource
End If
If currMonthNum = 1 Or currMonthNum = 2 Or currMonthNum = 3 Or currMonthNum = 4 Or currMonthNum = 5 Then
If api.Cons.IsLocalCurrencyforEntity() And Not api.Entity.HasChildren() Then
api.Data.Calculate("S#Forecast2:A#All = S#" & sScenario & ":A#All")
api.Data.Calculate("S#Forecast2:A#All:O#AdjInput = S#" & sScenario & ":A#All:O#AdjInput")
End If
End IfNot sure what I'm doing wrong. Any ideas?
Thanks!
You can write to AdjInput using api.data.calculate. Below is the simple formula which i ran using custom calculate DM job.
api.Data.Calculate("O#AdjInput:'all other filter'=O#Forms:'all other filter'")You can see the blue coloured cell which indicates calculated cell for AdjInput member.
You shouldn't have to specify AdjInput separately. Typically, for the items not specifically spelled out in the calculations, it will do the calc at all levels, meaning it should copy from Import, Forms, AdjInput, etc on its own.
