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

By Nesha Holmes

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

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

How To Guides

Mar 25 2024

Changes to Model Exports in SAC: No More File Repository

We all know that SAP Analytics Cloud, as a Software-as-a-Service product, evolves all the time. With this comes enhancements, new features, and additions. But

Mark McCausland

Quarterly Release Cycle

Feb 27 2024

Lite Viewer for Core BI Stories

Introduction to Lite Viewer for Core BI Stories SAP has released a Lite Viewer for Core BI Stories for SAC in 2024.02 QRC. It

Nesha Holmes

Quarterly Release Cycle

Feb 27 2024

Flexible Modeling

Introduction to Flexible Modeling in SAC In Q1 QRC one of the most visible updates you will see is to the modeler with the

Matthew O'Brien

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