4/11/2019
I got a question on Cube security.
Let’s say that I setup data access and it works fine.
Now what if the user is importing data using an Import profile?
Can they see data loaded by other users?
User 1 got access to Ent1 and Product1
User 2 got access to ent2 and Product2
They both got access to the same import profile, what happens in this scenario?"
If they have access to the import WF then the user should see all the stage data in that WF regardless of the entity cube security. Viewing the data in the cube via a cube view would obviously be another story.
I'm suggesting one import for each user with every combination to which that user has access. Think of it as this... I have access to import for three entities, I'm going to go to one WF that contains three entities. I'm not going to go to three WFs, one for each entity. Same idea.
So that would be 1000 users (assuming one user/group) and no one user has access to multiple entities, then that will work. Entities can't cross WFs or it will wipe out data
Whoever is following this, I went with a different approach
Users will click a button and that button will launch a powershell script with the admin id and password. I've workflows created for entities and they get loaded. Users doesn't have access to these workflows and they cannot see the data
