SAP Knowledge Base Article - Public

2958591 - Cannot set the time-range for additional date type dimension in SAP Analytics Cloud for Planning (SAC)

Symptom

  • It is possible to add a second Date type dimension to a planning model.
  • This is useful for instance to create a Posting date dimension to use to enter a new monthly plan each month and quickly switch between the different plans.
  • The Date type dimensions are populated by the system and cannot be manually edited.
  • In the case where two date type dimensions are created, the dimension chosen in the field "Date Dimension used for Planning" in the model properties will be limited by the "From" and "To" fields selected.   However, the second Date dimension will contain the complete list of years from 1900 to 2201. This makes it difficult to filter and select only the years needed in stories and other actions such as setting the data locks as expanding this dimension shows this long list of members.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.17

Cause

This is a current limitation of SAC. Any additional date type dimensions will show the complete list of possible dates and cannot be limited.

Resolution

This issue is currently under investigation by development.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-PL , Planning , Problem

Product

SAP Analytics Cloud 1.0