Forum Discussion

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
3 years ago

Data Buffer for reading another Scenario

Hello ! I would like to use a data buffer that would read data from another Scenario than the one set in my data management job, is it possible ? Right now, I have a simple formula that should re...
planning
SxD's avatar
SxD
New Contributor III
2 years ago

Any luck with this? Running into a situation where I would like to do this as well, especially since I have extensibility enabled across different scenario types. 

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
2 years ago

I worked a little bit more on the data buffer and indeed it can retrieve values from anywhere in the application, but it will write only on the current data unit.

Something like this will work for any data (ie even if the current data unit is for budget scenario, Entity B ...) :

Dim dbr_driver As DataBuffer = api.Data.GetDataBufferUsingFormula("removezeros(E#A:S#Actual:A#MyAccount)", DataApiScriptMethodType.Calculate, False, destinationinfo)