New Custom Function Added for Microsoft Office SAC Add-In: MEMBERPROPERTY

By Nesha Holmes
02/27/2024

Table of Contents

Feature Overview

SAP has added the SAP.MEMBERPROPERTY formula, which returns the value of a specified property for specified dimension members.

The information in the image above was provided by SAP’s Help Portal. Check out the ‘SAP Analytics Cloud Help Documentation’ for more details at https://shorturl.at/yHSZ3

Use Case

This function is useful when you want to identify what member IDs contain in a certain property value.

By identifying those member IDs, you can also nest the function inside of another Excel formula. For example, below, I have nested the SAP.PROPERTYMEMBER inside of an If/then statement to return a value for only those account types of income (INC).

Video Overview

Related Posts

Quarterly Release Cycle

May 20 2025

Smart Insights Available in Optimized Design Experience

Introduction The anticipated Smart Insight has been added to the Optimized Design Experience in the quarterly enhancements for QRC2 2025. This was previously available

Nesha Holmes

Quarterly Release Cycle

May 20 2025

Support of Story Filters with Linked Dimensions

Overview Data Analyzer now carries over the story filters with linked dimensions when selecting Analyzer on a widget within the story. This reduces time

Nesha Holmes

Quarterly Release Cycle

May 20 2025

Creation of a Performance Report in Microsoft Excel

Overview Starting with SAC QRC2 2025, users can enable a performance report within an Excel workbook. This allows users to track performance issues for

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