Advanced Formulas – Variable Member Support for Version Dimension

By Adam Arends
02/27/2024

Table of Contents

Introduction to Variable Members Support

Variable Members define and store calculated values within a Data Action script to be used throughout the script, limiting the need to recalculate values and adding efficiency to the entire script. Defining the Variable Member stores the data independent from the real dimension members.

Utilizing Version Variable Member in Advanced Formulas

In QRC1 2024 release, the Variable Member syntax is also extended to the Version dimension, creating a record set for a temporary version.

Extending the Variable Member to the Version dimension creates flexibility in Data Action design while providing clarity to the script and additional script optimization paths. When creating a variable member, the best practice is to create a member based on a dimension outside of the calculations being done within the script itself.

Variable Member = Data/Result Lookup Member:

Version Variable Member:

In the first script, all of the data stays within the same dimension, forcing the Variable Member to be cleared each time, adding bloat to the script and potentially slowing down the processing speed. In the second script, moving the Variable member to the Version dimension creates a separate value for each account and does not necessarily need to be cleared out to make the script run.

Final thoughts on Version Variable Members

The greatest benefit of the Version Variable Member is the clarity it brings to the script. Functionally, this option is like adding an AuditTrail (DataSource) to the script; however, there are times when the visibility of a new Version makes more sense than an AuditTrail (e.g., forecasting allocations in a Version instead of an AuditTrail might be better understood while also freeing up the AuditTrail for more flexibility in data tracing).

The Version Variable Member is a welcome addition to the data action scripting, and the capabilities it provides should greatly extend data action functionality.

Related Posts

Quarterly Release Cycle

Feb 12 2025

SAP Analytics Cloud Compass

Overview Let’s talk about Compass—and why it might just be the tool you didn’t know you needed! At its core, Compass is designed to

Ashvini Kulkarni

Quarterly Release Cycle

Feb 12 2025

Unit Conversion Support in Story Calculations

Overview Hello SAP Users! If you have ever worked with different units of measurement in your SAP Analytics Cloud stories, you know that it

Ashvini Kulkarni

Quarterly Release Cycle

Feb 12 2025

Show or Hide Chart Grid Lines

Overview While creating charts for your stories, have you wanted to enhance a viewer’s focus to one chart? With the newest update from SAP,

Mahira Hasan

New SAP Boosters!

Check out our newest array of SAP Boosters! This launch includes various topics, including Geo Maps, Using Aggregation to Create Master Data in SAP Datasphere, and using Data Actions for Currency Conversion.

Contact Us

Reach out if you have any questions or to see how we can create a custom training solution for your organization!

Contact Form Pop-Up - General Use

Custom Training Solution

Fill out and submit the form below, and we’ll reach out to you to discuss how we can work toward achieving your training goals in a way that works best for you and your team.

Contact Form - Custom Training