/sap-sac-planning

Data Action Tracing

Overview

Data Action Tracing is a debugging tool in SAP Analytics Cloud that allows executing a data action while inspecting intermediate results at manually specified locations called "tracepoints." This enables systematic debugging and validation of complex planning calculations.

Key Concept: Set tracepoints at specific locations in a data action, execute in trace mode, and examine data changes between tracepoints.

What You Can Do with Tracing

When to Use Data Action Tracing

Common Scenarios

Tracing vs. Regular Execution

Adding Tracepoints

Tracepoint Locations

Tracepoints can be added:

• Between steps - After any data action step
• Within advanced formulas - At specific calculation points
• Before/after allocations - To verify input and output

Adding a Tracepoint

1. Open data action in Data Action Designer
2. Navigate to the step where you want to add tracepoint
3. Click Add Tracepoint icon or right-click → Add Tracepoint
4. Name the tracepoint descriptively (e.g., "After Copy Step", "Before Allocation")

Tracepoint Naming Conventions

Running Data Action Tracing

Starting Trace Mode

1. Open data action in designer
2. Click Run with Tracing (or trace icon)
3. Set required parameters (if any)
4. Execute data action

What Happens During Tracing

┌────────────────────────────────────────────────────────────┐
│ Data Action Execution with Tracing                         │
├────────────────────────────────────────────────────────────┤
│                                                            │
│   Start ─────► Step 1 ─────► [TP1] ─────► Step 2          │
│                               │                            │
│                    Capture data snapshot                   │
│                                                            │
│   ─────► [TP2] ─────► Step 3 ─────► [TP3] ─────► End      │
│            │                          │                    │
│   Capture snapshot           Capture snapshot              │
│                                                            │
└────────────────────────────────────────────────────────────┘

Note: Execution does NOT pause at tracepoints—all data is captured and available after completion.

Analyzing Tracing Results

Viewing Results

After trace execution completes:

1. Tracing Results Panel opens automatically
2. Select a tracepoint from the list
3. View data in table layout (similar to story tables)

Result Views

Filtering and Navigation

Tracepoint Configuration

Tracepoint Options

Scope Configuration

Define what data to capture at each tracepoint:

Best Practices for Scope

1. Start broad - Full model for initial debugging
2. Narrow down - Filter to relevant data once issue identified
3. Use step scope - For performance-sensitive debugging
4. Custom filters - For large models with known data areas

Debugging Common Issues

Issue: Unexpected Values

Debugging Approach:

1. Add tracepoints before and after suspected step
2. Run in trace mode
3. Compare values at both tracepoints
4. Identify where incorrect transformation occurs

Issue: Missing Data

Debugging Approach:

1. Add tracepoint at data source (beginning)
2. Add tracepoints after each step
3. Find where data disappears
4. Check filters, mappings, or conditions

Issue: Allocation Problems

Debugging Approach:

1. Add tracepoint before allocation (source data)
2. Add tracepoint after allocation (distributed data)
3. Verify driver values are correct
4. Check allocation ratios match expectations

Issue: Formula Errors

Debugging Approach:

1. Add tracepoints within advanced formula
2. Check each calculation component
3. Verify lookup data is accessible
4. Validate date/version contexts

Tracing Advanced Formulas

Adding Tracepoints in Scripts

In advanced formula scripts, add tracepoints using TRACE() function:

// Advanced Formula Script with Tracepoints

// Calculate base revenue
[Revenue] = [Quantity] * [Price]
TRACE("After_Revenue_Calc")

// Apply discount
[Discounted_Revenue] = [Revenue] * (1 - [Discount_Rate])
TRACE("After_Discount")

// Calculate tax
[Final_Amount] = [Discounted_Revenue] * (1 + [Tax_Rate])
TRACE("After_Tax")

TRACE() Function

Performance Considerations

Tracing Impact

Optimization Tips

1. Minimize tracepoints - Add only where needed
2. Use filtered scope - Don't capture entire model
3. Remove after debugging - Delete tracepoints when done
4. Test on subset - Debug with filtered data first

Memory Considerations

Tracing captures data snapshots in memory:

• Large models may hit memory limits
• Use scope filters to reduce memory usage
• Consider debugging subsets of data

Workflow Best Practices

Development Workflow

1. Create Data Action
        │
        ▼
2. Add Tracepoints (before/after key steps)
        │
        ▼
3. Run with Tracing
        │
        ▼
4. Analyze Results
        │
        ├── If issues found ──► Fix and repeat
        │
        └── If correct ──► Remove tracepoints
                               │
                               ▼
                        5. Deploy to Production

Tracepoint Strategy

Tracing Output Format

Table View Structure

Change Indicators

Integration with Job Monitor

Tracing and Job Monitor

• Traced executions appear in Job Monitor
• Status shows "Completed with Tracing"
• Tracing results available for review
• Can re-analyze previous trace runs

Accessing Historical Traces

1. Open Job Monitor
2. Find traced data action execution
3. Click to view tracing results
4. Analyze as with live tracing

Note: Tracing results are stored temporarily and may be purged.

Troubleshooting Tracing Issues

Common Problems

Debug Checklist

• Tracepoints named descriptively?
• Scope appropriate for debugging need?
• Parameters set correctly?
• Model has data for selected scope?
• User has required permissions?

Official Documentation Links

• Data Action Tracing Overview: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/0767009b49d141c58fcc2962d6584b44.html
• Add Tracepoints: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/50424a6a40584f65a9b4c9493c18690c.html
• Run Tracing and Check Results: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/065dfca395724e369817f3ce05bb7184.html
• Data Actions: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/2850221adef14958a4554ad2860ff412.html
• Advanced Formulas: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/4af8f5afbaf541f5821107eb772a5224.html

Version: 1.0.0 Last Updated: 2026-06-11 SAC Version: 2026.8