Forum Discussion

Ioana's avatar
Ioana
New Contributor III
2 years ago

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

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!

Consolidation
Methodology
  • Omkareshwar's avatar
    Omkareshwar
    2 years ago

    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

  • Omkareshwar's avatar
    Omkareshwar
    Contributor II
    2 years ago

    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