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

Best Practices

May 30 2024

Unraveling the Benefits of Workplace E-Learning

In today’s fast-paced world, the digital learning space is always changing, making it essential for businesses to keep up. Digital learning is crucial, and

Cindy San

Quarterly Release Cycle

May 22 2024

Planning Trigger – updated formatting options formats

You now have the capability to establish and save default styling preferences for planning triggers. In addition, you can design the triggers using vector

Arthur Phung

Quarterly Release Cycle

May 22 2024

Design Pane Header Re-design

The design panel has separate icons for Tables, Data Action Triggers, and Data Source. The data source name and the table name for tables

Nesha Holmes

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