Partial XFSET Uploads

Forum|Forum|4 years ago
June 29, 2022
4 replies
0 views

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

Best answer by NicolasArgente

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

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

Hope it helps. 😉

N

NicolasArgente

Veteran

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

R

RonnieKarpinskAuthor

Newcomer

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