Forum Discussion

Patra's avatar
Patra
New Contributor II
30 days ago

copying quarterly inputted data into Monthly scenario

Hi, want to copy quarterly input data through business rule. the destination scenario is defined as monthly input. in the destination code , i want to specify months which system doesn't allow. we ...
System
XFBR
victortei's avatar
victortei
New Contributor III
30 days ago

Patra, as MarcR mentioned, yes OS can do it.

In your DM, you're gonna loop on your target periods. For instance, if you want to write to Jan, Feb, Mar of 2025, you would have T#2025M1, T#2025M2, T#2025M3 in the time filter.

Then, in your calculation, on the right side of your equation, you define where the system will pull the info from. (PS: You can never specify the Data Unit members on the left-hand side. Those are already taking into consideration the DM info you've already defined.)

Something like this:

api.Data.Calculate("V#Periodic = T#PovYearQ1:V#Periodic")

As MarcR mentioned, you can map that in various ways. You could use a Select Case based on the month, then you can pull data from specific quarters, etc.

Select Case api.Pov.Time.Name.Substring(4)
      Case "M1","M2","M3"
            '--code here
      Case "M4","M5","M6"
            '--code here
'etc...
End Select

Hope this helps!