SAP Knowledge Base Article - Public

2816628 - Do Advanced formulas support "Date Type" Attribute in "IF" condition in SAP Analytics Cloud (SAC) & SAP Digital Boardroom - 2019.14.1

Symptom

Is the script below supported in Advanced Formulas?:

IF ( [d/Employee].[p/StartMonth] = [d/Date] )

ENDIF

Or we have to explicitely put:

IF ( [d/Employee].[p/StartMonth] = "201901")

ENDIF

Environment

  • SAP Analytics Cloud 2019.14.1

Cause

This is a known restriction. The script above is not supported.

This one is supported:

IF ( [d/Employee].[p/StartMonth] = "201901")

ENDIF

Resolution

Advanced formulas currently does not support "Date Type" Attribute in "If" condition.

This issue is an enhancement request and development team will plan to implement it.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predicitive , Product Enhancement

Product

SAP Analytics Cloud 1.0