cancel
Showing results for 
Search instead for 
Did you mean: 

Partial XFSET Uploads

RonnieKarpinsk
New Contributor III

Hello,

Has anyone experienced partial uploads when using the XFSET formula? Does anyone know if there is a way to set XFSET uploads to only upload data if there aren't any errors? 

Regards,

Ronnie

1 ACCEPTED SOLUTION

NicolasArgente
Contributor II

Ronnie, unfortunately I did not get your error message, so i took the liberty to create a new one. See below.

2022-06-30_15-37-29.jpg

 

In other words, OneStream will push to the cube all valid formulae. Only those. So it is NOT all or Nothing.

Hope it helps. 😉

 

 

View solution in original post

4 REPLIES 4

NicolasArgente
Contributor II

Hello Ronnie!
You mean errors in the data or in the formula syntax? Anyway, if it is the data, like the value, then OS is not checking this. You can load any value. If it is the syntax, then OS will send an error and not load anything.
Hope it helps

RonnieKarpinsk
New Contributor III

Hello,

Thanks for your help! I would say errors in the formula, specifically users picking incorrect dimension members. I do not have a ton of experience with the Excel add-in yet. One of my primary Excel add-in users said if there were errors in a XFSET formula previously nothing would load at all in the sheet and she is saying now it is loading the data in the sheet without errors and then giving her this attached error message. We haven't made any changes, so I am trying to figure out the root cause, it could be user error. I am trying to better understand the behavior for XFSET formula loads. Will partial data upload as long as the formulas are correct and those with errors just bomb out, or is it all or nothing? Thanks!

Regards,

Ronnie

 

NicolasArgente
Contributor II

Ronnie, unfortunately I did not get your error message, so i took the liberty to create a new one. See below.

2022-06-30_15-37-29.jpg

 

In other words, OneStream will push to the cube all valid formulae. Only those. So it is NOT all or Nothing.

Hope it helps. 😉

 

 

RonnieKarpinsk
New Contributor III

Thank you, that is what I figured. I appreciate your help! 

Please sign in! RonnieKarpinsk