There is a requirement to use formulas and filters based on dynamic dates (e.g: CurrentDate()) in SAP Analytics Cloud.
- SAP BusinessObjects Cloud 2018.03
Reproducing the Issue
- Logon to SAP Analytics Cloud
- Create a story
- Add a widget to the story (e.g: Chart or table)
- Try to create a Calculated dimension using formulas based on current time
The function current year or current date are not available in SAP Analytics Cloud
- 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.
- How to find User Assistance for SAP Analytics Cloud?
- Ask a question on the SAP Community!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
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.
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