Validation Error: No security access to data cell being cleared
Hi Team,
We have a client that upload excel templates using xfdrange into OneStream.
They have different files per Business Unit (UD2). Two of the files run into the following intersection error during the validation step:
All the other files are correct, however, when they upload these two files, all data intersections (from all other files) are suddenly also invalid intersections. For examples, the line listed here is not from either of the two files but from a seperate file that has no errors when uploaded individually). When you would navigate to "Intersection" instead of "invalid Intersection (1)" all data intersections from all files are there. Only the local users get this validation intersection, when I (administrator) would run "Validate" from this screenshot, the error dissapears.
Strange thing is:
- they have uploaded data on this intersection before in previous Forecast Scenarios without errors
- Security has not changed for either the application, user, workflow profile, entity etc.
- these two files both have an account that is only used there but is set up in the same way as all the other accounts (and previously could be loaded in other scenarios). Could just be a coincidence.
- Application Security: ModifyData is set to Everyone
One thing to note is that this is a new forecast scenario we recently created for them, however, setup is the same way as the other forecast scenarios in terms of security.
I am also having a hard time understanding the error and why it is refering to "clearing data" in the validate step.
Anyone that can help me a little bit more in understanding the error or knows what could cause this?
Thanks in advance!