1.1 KiB
1.1 KiB
Advanced Formulas (SAC 2025.23)
Purpose: scripted calculations in data actions; choose visual editor for simple flows or script editor for full control.
Authoring modes
- Visual: guided blocks for scopes, loops, assignments (027-advanced-formulas-scripts.md, 028-advanced-formulas-visual.md).
- Script: free-form syntax; full reference in 029-advanced-formulas-script-reference.md.
Common patterns
- RESULTLOOKUP for driver retrieval; MEMBERSET for scoped loops; FOREACH for dimension iteration; IF/ENDIF for branching; DATA() for writes.
- Time offsets: use OFFSET on Date; handle week/month/year granularity explicitly.
- Exception aggregation: avoid mixing calculated members in copy rules where not supported.
Performance tips
- Narrow MEMBERSET scopes (time/version/org) before calculations.
- Use temporary variables; minimize writes inside loops.
- Prefer APPEND vs OVERWRITE intentionally; chunk large periods.
Testing
- Validate on small slice; check job monitor for syntax/validation errors.
Sources: 027, 028, 029 advanced-formulas docs (SAC Help 2025.23).