New Function for Microsoft Add-in: SAP.TIMEOFFSET

By Nesha Holmes
02/27/2024

Table of Contents

Feature Overview

SAP has added a new function that returns dynamic times based on a reference date. The resulting times can be used in conjunction with other functions (e.g., OVERWRITE, GETDATA), which make your tables more flexible for users. Currently, the function only works with hierarchies and does not work with SAP BW or SAP S/4HANA.

The formula requires:

  • Data Source
  • Reference Date
  • Offset time periods from the reference date.
    • For example, assuming the reference date is 202401 and the offsets are -1,0,1,2 then the time periods will be 202312, 202401, 202402, 202403.
  • The display format to be used.
    • 0 for ID (default)
    • 1 for description
    • 2 for ID and description (displayed in two separate cells)
    • 3 for description and ID (displayed in two separate cells)
  • The orientation to be used.
    • 0 for vertical
    • 1 for horizontal (default)
  • Dimension (optional).
    • If you want to apply the formula to another dimension that is not the default time dimension of the data source, you can specify this other dimension.

Incorporating the OVERWRITEDIMENSIONFILTER function with the TIMEOFFSET function, we can change the dates in the table based on the reference date. The TIMEOFFSET function can also be nested within the OVERWRITEDIMENSIONFILTER in place of the “members” argument.

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

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.

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