Bypass Certified Entities upon Import
Hi, we are using a Central Load workflow to load trial balances for ~1,500 entities(set up as unrelated entities). There are then approx 50 "Central Import" workflows where Entities are assigned and...
Forum Discussion
Correct, you can actually open the file and create the 50 versions of the file with only the assigned Entities in each of the 50 through a BR. Then in the rule you can check the WF Status before you execute Import. This would make sure that the Stage Records match the Cube and not have the link compromised.
Eric, I'm very late to the party here, but couldn't you also add a Complex Expression to the Entity dimension of the Data Source that would reject any record that didn't belong to the Workflow's Assigned Entities? That way you could create the 50 Workflows, each with their own assigned entities, and literally load the same file to all 50 Workflows.
The Complex Expression for the Data Source's Entity dimension would look something like this:
Dim entity As String = args.Value
Dim profileEntityInfo = New List(Of WorkflowProfileEntityInfo)( brapi.Workflow.Metadata.GetProfileEntities(si,api.WorkflowProfile.ParentProfileKey))
Dim profileEntityInfoString = New List(Of String)(profileEntityInfo.ConvertAll(Function(x) x.EntityName))
If profileEntityInfoString.Exists(Function(x) x = entity) Then
Return args.Value
Else
Globals.Bypass = True
End If