Problem
When an Anaplan saved view is used as a pipeline source, Data Orchestrator exports the data in a flat format rather than preserving the view’s pivot. For example, if time periods are displayed as columns in the saved view, the pipeline places Time in a single column and creates a separate row for each period.
This can produce a different file structure from an existing Anaplan export action based on the same view: more rows and fewer columns. As a result, automating an established export through a pipeline may require changes to downstream systems and processes that already rely on the current file format.
Proposed enhancement
Add an optional output setting that allows users to preserve the saved view’s pivoted layout when exporting through a Data Orchestrator pipeline to Amazon S3 or another destination.
Users could choose between:
- Flat format — the current pipeline behavior.
- Saved view layout — retain the dimensions and time periods as rows and columns as configured in the saved view.
The existing flat format should remain the default. Anaplan could also warn users that changes to the saved view or time periods may change the output schema.
Business value
This would make it easier to automate existing exports without redesigning downstream integrations, reduce implementation effort and migration risk, and give users more flexibility when a destination expects a pivoted file.