What should I do when I encounter a situation where three sources need to be mapped simultaneously?
Hi there, within each import action you will be asked to mapped each dimension of a module (target) to an element within the file or a fixed value (aka source). In this example, the module has three dimensions/targets: departments, roles, and line items.
The mapping for the first 2 targets appear correct, the third you will need to update to map to the line items to the "Drivers" column. Once complete, open the tab labeled "EMP03 Employee Drivers by Role Line Items" you can then review how each driver in the file maps to a line item in the module. Note you have titled a line item as "Bonus %" whereas the file lists it as "Bonus Percentage", thus the you may need to manually map those items together.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…