Interesting, i wonder if you have the security access set to “view” only? Then they wont have access to actually upload data through their dedicated workflows…
That is actually a good call out because i didn't check it down to the user level before posting but sadly that was not it, It does let them load it just fails at the transformation step. Thank you though
If you have already set up security groups for entities, cubes, and workflow profiles in OneStream to restrict access to specific data, but you are still encountering "No Security Access" errors when running transformation rules, there are a few potential issues to consider:
1. Data Access settings on the Cube:
- Ensure that the cube's Data Access settings are configured correctly to align with the security groups you have defined. Check if the security group associated with the user running the transformation rules has appropriate access permissions for the relevant dimensions and members in the cube. You can review and modify these settings in the Cube Editor within OneStream.
2. Dimensional Security:
- Check if you have implemented proper dimensional security in OneStream. Dimensional security allows you to control access to specific members within dimensions. Ensure that the dimensional security settings align with the security groups assigned to users, so they have access to the necessary dimension members required for the transformation rules.
3. Data Access Settings in the Workflow:
- Verify that the workflow profile associated with the transformation rules has the correct data access settings. In the workflow profile, ensure that the security group assigned to the user running the transformation rules has appropriate access privileges for the required entities and dimensions.
4. Escalation Rules:
- Confirm that the escalation rules in OneStream are configured correctly. Escalation rules help determine the effective security access rights for users based on their group assignments. Double-check if the escalation rules are properly configured to assign the expected security groups to users.
5. Analyze Transformation Rule Execution:
- Enable the OneStream debug mode for transformation rules and examine the generated log files. The log files may provide more detailed information about the specific security access issues encountered during rule execution.
Hope this helps.
Thanks,
Nick Hymes
Archetype Consulting
