Forum Discussion

FabioG's avatar
FabioG
Contributor
11 days ago

Calculate values in different scenarios

Hi all,

I tried to issue an api.Data:calculate with the following (fake) formula :

A#ACCXXX:F:MYFLOW:S#MYSCEN = A#ACC001:F#CHI:S#ACT

Of course OS complains because I'm reading from the current Scenario (ACT) but I want to write in a different Scenario that implies a different Data Unit (is it ?)

While being in ACT scenario, if I would switch to DataBuffers to write in the destination Scenario (is it?)

Could someone point me in the right direction ? 

I did this, but looks like it doesn't write a **bleep** !

Dim _srcDC As DataCell = api.Data.GetDataCell("A#ACC001:F#CHI:S#ACT")



Dim _targetDB As New DataBuffer()

Dim _dcNew As DataCell = New DataCell(_srcDC)

_dcNew.SetScenario(api, "MYSCEN") ' This WON'T CHANGE <===================

_dcNew.SetAccount(api, "ACCXXX") ' This Change

_dcNew.SetFlow(api, "MYFLOW") ' This Change

_targetDB.SetCell(si, _dcNew)

api.Data.SetDataBuffer(_targetDB, _destinationInfo)

In the end, works fine... just doesn't change the Scenario... :-/ What am I doing wrong ? 
 
Thanks in advance for your help
 
FabioG
Extensibility
Methodology

1 Reply

  • MarcusH's avatar
    MarcusH
    Valued Contributor
    7 days ago

    You cannot update a different data unit. If you want to update a different scenario or entity for example, you have to change the POV to the scenario / entity that you want to update. This will work fine if your current scenario is MYSCEN:

    A#ACCXXX:F:MYFLOW:S#MYSCEN = A#ACC001:F#CHI:S#ACT