complex load from SAP to Anaplan that cause performance issues ?

lakshmidarisi2025

Q :When dealing with complex data loads from SAP to Anaplan that causes performance issues ?What are the approaches need to consider in mind before or after the load ?

Q : And the load happens now model is taking more time to load ? How to tune the model in this scenario?

rob_marshall

@lakshmidarisi2025

Yep, that doesn't really help. Have you read this?

Link

rob_marshall

@lakshmidarisi2025

Can you please define "complex" load?

lakshmidarisi2025

@rob_marshall huge / bulk load volume

araj

• @lakshmidarisi2025 some best practices to follow before the load from any ERP system to Anaplan

• Data Preprocessing (in SAP or Middleware):
  • Filter only relevant data (e.g., delta loads instead of full loads).
  • Aggregate data if detailed granularity isn’t needed in Anaplan.
  • Format data to match Anaplan's import schema (dates, text length, null values, etc.).

• Limit Volume per Load:
  • Break down large loads into smaller batches (e.g., per region, per month).
  • Use time-phased loads to avoid importing multiple years of data at once.

• Optimise Data Hub (if used):
  • Stage the raw SAP data in a Data Hub model before pushing it to spoke models.
  • Clean, map, and transform data in the Data Hub to reduce the burden on business models.

• Indexing and Code Usage:
  • Use codes for list items (instead of names) for faster matching.
  • Ensure unique keys are properly used to avoid duplication issues.

seymatas1

Hi @lakshmidarisi2025,

You may want to consider using Anaplan Data Orchestrator (ADO) instead of a Data Hub for large data uploads since hyperblock is optimized for calculations, but ADO is optimized for handling large volumes of data.