Forum Discussion

Rianne's avatar
Rianne
New Contributor II
3 months ago

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 d...
Data Integration
Import
Transformation
Workflow
WiskiOne's avatar
WiskiOne
New Contributor III
5 days ago

Hi Rianne,

We have the same error in one of our import/validate/load processes. In our case, it seems that the error is related to the import-type workflow engine. According to our investigation, in these cases, OneStream reviews all the workflow steps that are siblings and of the import type from top to bottom. It deletes the data loaded into the cube and revalidates and reloads in the mentioned order. Our model has security defined by cube at the UD1 (Business Unit) level. The information for each BU is loaded in a different step of the workflow. These steps are siblings. Considering what I mentioned, users with BU-level security experience this error because the system is trying to delete the data loaded in the other sibling steps.

Regards,

Xavi