I am stuck on the pivots and exports needed for INV05, DEM04, and INV01. I have been at it all day and feel like I have tried every combination, but when I try to import, I am getting errors or failure.
@pjc95
Hang in there. All that time is well spent - good investment as it will sharpen your data integration skills which is one of the most important skills to have as a modeler. Start by creating the view you want. As a suggestion, try to remove all the aggregate values so you only have the grain of the data. We do this to avoid ignores and errors. You'll need to use filters for this. For example, INV05 we only need Shipping Costs but we have 3 lists to contend with: Location and time. But we need the location code as well. So here's one way you can create that view:
Nicely handled @pjc95
We are pleased to announce the upcoming FCR 2610.1 GA release scheduled for next week, the week of October 19th, 2026. Highlights Last Twelve Months (LTM) Calculation The system will automatically calculate Last Twelve Months (LTM) or Trailing Twelve Months (TTM) data using this calculation. LTM amount will be stored as a…
Check out the latest Anaplan feature updates and enhancements in our September 2026 official release notes. There you'll find information on: User Experience KPI cards Mobile Zoom and pan KPI Conditional formatting Intelligence CoModeler Analyst Optimizer Disclosure Management Refreshed user interface Anaplan Data…