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

Ioana
New Contributor III

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!

1 ACCEPTED SOLUTION

Omkareshwar
Contributor II

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

Thanks, Omkareshwar
Archetype Consulting

View solution in original post

1 REPLY 1

Omkareshwar
Contributor II

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

Thanks, Omkareshwar
Archetype Consulting
Please sign in! Ioana