Shopping Cart

No products in the cart.

Quarterly Release Cycle

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

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .

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