SAP Knowledge Base Article - Public

3408831 - Restricted Measure combined with Selection Context NAVIGATION, Dynamic Date Range, and Custom Date Input Control in SAP Analytics Cloud (SAC)

Symptom

  • Widget displaying Restricted Measure with "NAVIGATION > Previous" Date Selection Context results in error:
    "Add the "date" dimension to the widget or create a single-value filter on "date" for "Restricted Account 1" to appear".
  • Widget has Dynamic Date filter linked to Date Input Control.
  • After picking a custom date in a Date Input Control, the error occurs.

Environment

  • SAP Analytics Cloud 2023.21
       
  • Optimized Design Experience Story

Reproducing the Issue

  1. Create a widget such as a table or chart in a Story in SAP Analytics Cloud.
  2. Create a Restricted Measure with Selection Context:
    • Dimension = "Date"
    • Value = "Navigation > Previous > Year"
  3. Apply a Dynamic Date Filter to the widget with configurations:
    • Current Date set to a Custom Date Input Control with date granularity Month as an example.
    • Range has date granularity Year as an example.
    • Note: The Input Control and Range are using different date granularities.
  4. Notice error "Add the "date" dimension to the widget or create a single-value filter on "date" for "Restricted Account 1" to appear".

Cause

  • This issue is currently under investigation by development.

Resolution

  • This issue is currently under investigation by development.

Workaround

  • The widgets Dynamic Date Filter Range and Input Control are using the same date granularity.

See Also

Keywords

restricted measure navigation dynamic date filter shift previous value input control date granularity , KBA , LOD-ANA-UNS-DSG , Unified Story Designer Issues , LOD-ANA-DES-CAL , SAC Story Calculations , Problem

Product

SAP Analytics Cloud 1.0