SAP Analytics Cloud Scripting

Comprehensive skill for scripting in SAP Analytics Cloud (SAC) Analytics Designer and Optimized Story Experience.

Plugin Components

This plugin provides specialized tools for SAC development:

Agents (use via Task tool):

• •sac-script-debugger - Debug script errors, trace issues
• •sac-performance-optimizer - Analyze and fix performance bottlenecks
• •sac-planning-assistant - Guide planning operations and version management
• •sac-api-helper - Find correct APIs and provide code examples

Commands (use via /command):

• •/sac-script-template - Generate script templates (filter, planning, export, etc.)
• •/sac-debug - Interactive debugging guidance
• •/sac-optimize - Performance analysis and recommendations
• •/sac-planning - Planning operation templates

Hooks:

• •Automatic validation on SAC script writes for common issues

What's New in Q4 2025 (2025.21)

Key scripting enhancements in the latest SAC release:

• •Chart Variance APIs - Script control over chart variance display
• •Compass for Seamless Planning - Enhanced planning integration
• •Data Actions Enhancements - Automatic dimension mapping, input control binding
• •Time Series Forecast API - Programmatic forecasting control
• •Comments APIs - Widget and cell comment management

See references/whats-new-q4-2025.md for complete details.

Quick Start

Script Editor Access

• •Analytics Designer: Edit mode → Select widget → Scripts tab
• •Optimized Story Experience: Advanced Mode → Select widget → Add script

Basic Script Structure

// Event handler example (onSelect on Chart_1)
var selections = Chart_1.getSelections();
if (selections.length > 0) {
    var selectedValue = selections[0]["Location"];
    Table_1.getDataSource().setDimensionFilter("Location", selectedValue);
}

Core APIs

DataSource API

Access via Widget.getDataSource(). Key methods:

• •getMembers(dim, {accessMode: MemberAccessMode.BookedValues}) - Get dimension members efficiently
• •getResultSet() - Cached data access (preferred over getData())
• •setDimensionFilter(dim, value) - Apply filters
• •setRefreshPaused(true/false) - Batch multiple operations

Planning API

Access via Table.getPlanning(). Key operations:

• •getPublicVersion() / getPrivateVersion() - Version access
• •publish() - Submit private to public
• •copyFromPublicVersion() / copyToPublicVersion() - Data copy
• •setLock(true/false) - Data locking

Widget APIs

• •Charts: addMeasure(), addDimension(), getSelections()
• •Tables: addDimensionToRows(), setZeroSuppressionEnabled()
• •Containers: Panel, TabStrip, PageBook for layout

Application Object

Global utilities:

• •Application.showBusyIndicator() / hideBusyIndicator()
• •Application.showMessage(type, text)
• •Application.getUserInfo() / getInfo()

Performance Best Practices

1. •

   Minimize Backend Calls

   javascript

   // Use getResultSet() (cached) instead of getMembers() (backend)
   var data = ds.getResultSet();
   

2. •

   Batch Filter Operations

   javascript

   ds.setRefreshPaused(true);
   ds.setDimensionFilter("Dim1", value1);
   ds.setDimensionFilter("Dim2", value2);
   ds.setRefreshPaused(false); // Single refresh
   

3. •

   Keep onInitialization Empty Defer heavy operations to lazy loading or first interaction.

4. •

   Use BookedValues for Members

   javascript

   var members = ds.getMembers("Dim", {accessMode: MemberAccessMode.BookedValues});
   

Debugging

Console Logging

console.log("Debug:", myVariable);
console.log("Selections:", JSON.stringify(Chart_1.getSelections()));

Browser DevTools

1. •Press F12 → Console tab
2. •Filter by "Info" type
3. •Add ?APP_PERFORMANCE_LOGGING=true to URL for timing

Bundled Resources

Reference Files (55 files):

• •Core APIs: references/api-datasource.md, references/api-widgets.md, references/api-planning.md
• •Advanced: references/api-calendar-bookmarks.md, references/api-advanced-widgets.md
• •Best Practices: references/best-practices-developer.md, references/best-practices-planning-stories.md
• •Language: references/scripting-language-fundamentals.md
• •Q4 2025: references/whats-new-q4-2025.md, references/chart-variance-apis.md

Templates (56 patterns):

• •templates/common-patterns.js - 40 general scripting patterns
• •templates/planning-operations.js - 16 planning-specific patterns

Official Documentation

• •Analytics Designer API: https://help.sap.com/doc/958d4c11261f42e992e8d01a4c0dde25/release/en-US/
• •Optimized Story Experience API: https://help.sap.com/doc/1639cb9ccaa54b2592224df577abe822/release/en-US/
• •SAC Documentation: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD
• •What's New Q4 2025: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/c96a267c5da04fff90bb55313ee9f77c.html

Version: 3.0.0 | Last Verified: 2025-12-27 | SAC Version: Q4 2025 (2025.21) | API Version: 2025.19