complex load from SAP to Anaplan that cause performance issues ?

lakshmidarisi2025
lakshmidarisi2025
in Modeling

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?

Best Answer

Answers

  • rob_marshall
    rob_marshall

    @lakshmidarisi2025

    Can you please define "complex" load?

  • lakshmidarisi2025
    lakshmidarisi2025

    @rob_marshall huge / bulk load volume

  • araj
    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
    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.

Categories