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

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

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 .
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.

Keyboard Arrow Right Streamline Icon: https://streamlinehq.com Show Me

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