XfSetCell vs data imported - which one will remain in the cube after consolidation?

[Ioana]

If I have data coming from a connector in OneStream, and then I submit a sheet having XfSetCell formulas, what values will remain in OneStream after consolidation (having the same dimensions intersection)? The data coming from the connector, or the data submitted via XfSetCell?

Thanks!

[Omkareshwar · Accepted solution]

Hi loana,

The data that is received through the connector will be stored in the O#Import origin member. However, it's important to note that you cannot directly enter data into the O#Import member. Instead, you can import or write data through a business rule on the O#Import member. Therefore, there is no possibility for data overlap between the connector and the XFSetCell as they operate on different dimensions.

On the other hand, data from the XFSetCell will be directed to the O#Forms origin member. Since these two origins (O#Import and O#Forms) have separate dimensions and data can only be written through a business rule on O#Import, there will be no conflict or overlap between the two.

Thanks,

Omkareshwar

Archetype Consulting