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
Valued Contributor

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. 😉

 

 

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

View solution in original post

4 REPLIES 4

NicolasArgente
Valued Contributor

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

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

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
Valued Contributor

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. 😉

 

 

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

RonnieKarpinsk
New Contributor III

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

Please sign in! RonnieKarpinsk