🔍 What You're Doing
This is the core of the audit pipeline. Anaplan's raw audit events arrive as a stream of records carrying internal IDs and numeric event codes that are not analyst-ready. This Pipeline joins the events to your Anaplan Users, Workspaces, Models, and Action records (the combined output from Step 5), then layers on the human-readable event messages from your Activity Event Codes lookup. The result is a single enriched dataset where every audit record carries who did what, in which workspace and model, against which action, and what that action means in plain language.
You describe the join logic as a sequence of phases in plain English, and AI Copilot generates the deterministic transformation steps for you to review before they run on your data.
✅ Summary of Steps
From the Workflow's Pipelines tab, click Add to create a new Supporting Pipeline.
Enter Augment Events in the Name field and click AI Copilot.
Add the following six datasets: Anaplan - Events, Anaplan - Users, Anaplan - Workspaces, Anaplan - Models, Activity Event Codes, and the Stack Actions output.
Set Anaplan - Events to Primary and confirm all six datasets are listed.
Click into the description text area and paste the prompt below. Drag the resize handle to expand the text area if needed.
Click Generate Instructions, review the AI-generated plan, and click Approve & Build.
Watch the Pipeline build out each transformation, then click the last transformation step to view the enriched output.
📋 Prompt to Copy
Paste this into the AI Copilot description field in step 5:
All joins LEFT with automatic column types. Rule: right after any join that brings in "name", rename it before the next join runs. Build in this exact order:
1. Left join Anaplan - Users on userId=id. Rename userId->USER_ID, userName->USER_NAME.
2. Left join Anaplan - Workspaces on additionalAttributes.workspaceId=id. Rename additionalAttributes.workspaceId->WORKSPACE_ID, name->WORKSPACE_NAME.
3. Left join Anaplan - Models on additionalAttributes.modelId=id. Rename additionalAttributes.modelId->MODEL_ID, name->MODEL_NAME.
4. Left join Stack Actions (supporting pipeline) on additionalAttributes.actionId=id. Rename additionalAttributes.actionId->ACTION_ID, name->ACTION_NAME.
5. Left join Anaplan - CloudWorks Jobs on objectId=integrationId. Rename name->CLOUDWORKS_NAME.
6. Insert empty OBJECT_TYPE; Mapping Group on OBJECT_TYPE (any + condition): where CLOUDWORKS_NAME is not empty => "CloudWorks Integration".
7. Copy CLOUDWORKS_NAME -> OBJECT_NAME.
8. Left join AUDIT_act_codes on eventTypeId=Event Code. No renames.
