SAP Analytics Cloud Scripting

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

Getting Started

When the user invokes this skill with no specific task (e.g. "help with SAC scripting", "use SAC scripting skill", or no follow-up question), respond with this structured orientation:

Welcome! I can help you with SAP Analytics Cloud scripting.

First, which environment are you working in?

Analytics Designer — application-based scripting, full API

Optimized Story Experience — story-based scripting, OSE API (v2025.14)

Then, what do you need help with?

Write a new script (filter, planning, navigation, export...)

Debug an existing script

Optimize performance

Find the right API method

Planning operations (version management, data locking...)

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

MCP Setup

This plugin ships with a

.mcp.json

that connects to the community

sap_analytics_cloud_mcp

server, exposing 90 SAC REST API tools across 11 service areas (Content, Data Export, Data Import, Multi Actions, Calendar, Content Transport, User Management, Monitoring, Schedule & Publication, Translation, Smart Query).

Before using MCP tools, check if the server is already installed:

Look for
```
.claude/sac-mcp.local.md
```
in the project
Or check if
```
SAC_MCP_PATH
```
is set in the environment

If not installed, ask the user once: "Would you like help setting up the SAC MCP server?"

If yes, guide them through:

Clone and build:

bash

git clone https://github.com/secondsky/sap_analytics_cloud_mcp
cd sap_analytics_cloud_mcp && npm install && npm run build

Configure environment variables:
- ```
SAC_MCP_PATH
```
  — absolute path to the cloned repo (e.g.
```
/home/user/sap_analytics_cloud_mcp
```
  )
- ```
SAC_BASE_URL
```
  — SAC tenant root URL (e.g.
```
https://mytenant.eu10.hanacloudservices.cloud.sap
```
  )
- ```
SAC_TOKEN_URL
```
  — OAuth token endpoint
- ```
SAC_CLIENT_ID
```
  /
```
SAC_CLIENT_SECRET
```
  — from SAC OAuth client configuration

After successful install, write

.claude/sac-mcp.local.md

(gitignored) with:

markdown

# SAC MCP Installation Record
- Installed: [date]
- Path: [absolute path to build/index.js]
- Env vars configured: SAC_MCP_PATH, SAC_BASE_URL, SAC_TOKEN_URL, SAC_CLIENT_ID, SAC_CLIENT_SECRET

This prevents re-prompting in future sessions.

What's New in Q1 2026 (2026.2)

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-q1-2026.md

for complete details.

Environment Detection

Before writing or analyzing any script, identify which SAC environment the user is working in.

Detection signals:

Signal	Environment
Mentions `.story` , "Optimized Story", OSE, `Story.` , `Application.getActivePage()`	OSE
Mentions Analytics Designer, `AnalyticApplication` , `Designer` , `.application`	Analytics Designer
Says "SAC script" / "my script" without further context	Unclear

When environment is unclear, ask ONE concise question before proceeding:

"Are you scripting in Analytics Designer or Optimized Story Experience? This determines which API reference I use."

Do not ask again after the user answers.

After confirmation, use the correct references:

OSE →
```
references/ose-api-*.md
```
(8 files, Q1 2026, v2025.14)
Analytics Designer →
```
references/api-*.md
```
(existing files)

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

javascript

// 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

Minimize Backend Calls

javascript

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

Batch Filter Operations

javascript

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

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

Use BookedValues for Members

javascript

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

Debugging

Console Logging

javascript

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

Browser DevTools

Press F12 → Console tab
Filter by "Info" type
Add
```
?APP_PERFORMANCE_LOGGING=true
```
to URL for timing

Bundled Resources

Reference Files (63 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

Q1 2026:

references/whats-new-q1-2026.md

references/chart-variance-apis.md

OSE API (Q1 2026, v2025.14) — complete method/parameter/return documentation:
- ```
references/ose-api-application-core.md
```
  — Application, PageBook, Panel, Popup, Widget (15 classes)
- ```
references/ose-api-widgets.md
```
  — Button, Dropdown, InputField, Slider, Switch, Text, TextArea (15 classes)
- ```
references/ose-api-datasource.md
```
  — DataSource, DataAction, DataBinding, DataLocking, DataChangeInsights (39 classes)
- ```
references/ose-api-chart-viz.md
```
  — Chart, Table, GeoMap, RVisualization, ValueDriverTree (20 classes)
- ```
references/ose-api-planning-calendar.md
```
  — Planning, PlanningModel, all Calendar classes (54 classes)
- ```
references/ose-api-filtering-selection.md
```
  — FilterLine, FilterValue, Selection (11 classes)
- ```
references/ose-api-utilities.md
```
  — BookmarkSet, MemberInfo, DimensionInfo, Timer, NavigationUtils (37 classes)
- ```
references/ose-api-types-enums.md
```
  — All enum types: Feed, Layout, NumberFormat, VariableValue (70 classes)

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.1 | Last Verified: 2026-03-07 | SAC Version: Q1 2026 (2026.2) | API Version: 2025.14

sap-sac-scripting

NPX Install

Tags

SKILL.md Content

SAP Analytics Cloud Scripting

Getting Started

Plugin Components

MCP Setup

What's New in Q1 2026 (2026.2)

Environment Detection

Quick Start

Script Editor Access

Basic Script Structure

Core APIs

DataSource API

Planning API

Widget APIs

Application Object

Performance Best Practices

Debugging

Console Logging

Browser DevTools

Bundled Resources

Official Documentation