2464206 - Dynamic dates in formulas in SAP Analytics Cloud

SAP Knowledge Base Article - Public

2464206 - Dynamic dates in formulas in SAP Analytics Cloud

Symptom

There is a requirement to use formulas and filters based on dynamic dates (e.g: CurrentDate()) in SAP Analytics Cloud.

Environment

  • SAP BusinessObjects Cloud 2018.03

Reproducing the Issue

  1. Logon to SAP Analytics Cloud
  2. Create a story
  3. Add a widget to the story (e.g: Chart or table)
  4. Try to create a Calculated dimension using formulas based on current time

Cause

The function current year or current date are not available in SAP Analytics Cloud

Resolution

  • This feature is currently evaluated by development and product management

What you can use are Dynamic Filters based on the current date. For a complete step-by-step guide on how to achieve it, you can check the KBA 2611798 - How to filter data based on current date in SAP Analytics Cloud

  • An enhancement request has already been submitted for adding date-type of formulas available for the user. You can subscribe and vote for the enhancement: Dynamic Date Filters

This Knowledge Base Article, SAP‘s strategy, and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice.
This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a
particular purpose, or non-infringement.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, SAC, AnalyticsCloud, dynamic date, filters, current date, current time, current year, current month, document date , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0