✆ UAE: +971 58 5616 616, ✆ USA:+14099168409,   ✉ info@insightcubes.com

How to Create, Update, And Delete Members with Planning APIs

Let us say you want to add a member to a dimension, in the following example we will be using a dimension called scope and a member along with the attributes will be added, the attributes will define the member. To use the planning APIs you must select a planning model under Planning Models Objects.

Planning apis in this blog:

  • createMembers() – Allows you to create Planning Model members. Note that the member ID must not be used before.
  • updateMembers() – Updates Planning Model members.
  • deleteMembers() – Deletes Planning Model members.

The below image is of the Add New Scope (member) tab in the Scope maintenance interface popup.

Add new Scope tab in Popup

The below code is linked through a Script Object Utils to the Create button of the Add New Member Tab.

The Script Objects Utils “createNewScope” adds the new member after clicking the Create button.

Script Object Utils for adding new scope

The below image is of the Edit existing Scope (member) tab in the Scope maintenance interface popup.

Edit Existing Scope tab in popup

The below code is linked through a Script Object Utils to the Update button of the Edit Existing Member tab.

The Script Objects Utils “updateExistingScope” applies all the edits to the member after clicking the Update button

Edit Existing Scope Script Object Utils code

Delete Existing Scope Tab in Popup

The below code is linked through a Script Object Utils to the Delete button of the Delete Existing Member Tab.

The Script Objects Utils “deleteExistingScope” deletes an existing member after clicking the Delete button.

Delete Existing Scope Script Object Utils code

And there you have it—you now know how to use planning APIs to create, update, and delete members. You can find more how-tos for SAP Analytics on our blog. You can also view more of InsightCubes’ SAP Software.

Recent Posts

Switch Themes in SAP Analytics Cloud

By leveraging the power of Theme Builder and integrating JavaScript and CSS, users can seamlessly tailor their dashboards’ appearance to align with specific brand guidelines and aesthetic preferences.

Ownership interface of the consolidation solution for SAP analytics cloud

Managing Ownership Structure

Explore how Consolidation Extension for SAC simplifies managing ownership structures, spanning from creating and editing scopes to assigning ownership methods and percentages for accurate consolidation.

Systems Check and Referential Integrity Interface

Learn how SAP Analytics Cloud’s Consolidation Extension ensures data accuracy with system checks and referential integrity, ensuring proper configuration and identifying inconsistencies in design.

account configuration guide for the consolidation extension

Account Configuration Guide

Detailed guide with automated checks and inconsistencies identification on account configure for automated eliminations, cascading behavior, currency conversions and other rules

Configuration Starter Kit

Summary of all the features and automated system integrity rules included in identifying issues with designs covering scope, currency, account, audit, flow and other dimensions

Get in Touch

Learn more and ask us About Our Cloud Consolidation Solution

Share This Post

Share this Page!

Share this with your network.

Want to Know More?

Get In Touch

Something isn’t Clear?


Feel free to contact us, and we will be more than happy to answer all of your questions.