SAP Knowledge Base Article - Public

2716727 - Story filters remove calculated values for functions with LOOKUP, RESTRICT and other calculated measures based on previous date in SAP Analytics Cloud


  • Model calculations using LOOKUP, LASTPERIODS, PREVIOUS functions stop working correctly, when filter is applied based on a date.
  • Behavior is also the same when using calculated measures (Restricted Measures) created on story level.
  • Widget filter does not brake the calculation.


  • SAP Analytics Cloud 2018.20

Reproducing the Issue

  1. Create a dimension with the format: LOOKUP([Quantity Sold], [Date] = LastPeriods ("Month", 12))
    or by using Restricted Measure with Values for Previous year.
  2. Measure returns correct values for months in the table a year before.
  3. Add a story filter to filter data for year 2015 only.
  4. The calculated values are vanished and calculation does not show values anymore.


This issue is currently under investigation by Development.


This issue is currently under investigation by Development.

See Also

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


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 , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem


SAP Analytics Cloud 1.0