SAP Knowledge Base Article - Public

2556694 - Story time filter does not work as expected in SAP Analytics Cloud (BOC) - 2017.23

Symptom

  • When adding the TIME dimension in Rows or Columns using a Story Filter or input control (and not Time Filter inside the table), there is always a "all" which can be developed to show the filtered Years.
  • The flat presentation is not used when you use dynamic time calculations (restricted measure referring to previous period) and the granularity of the time dimension is Year.

jjj.png

Environment

  • SAP Analytics Cloud 2017.23

Reproducing the Issue

  1. Create a story using a canvas page 
  2. Create a Story Time Filter on a year
  3. Create a table with Time in Row or Column
  4. Do not use the flat presentation 
  5. Note the "all" always displayed

Cause

This behaviour is by design in the project now.

When you create a story/page filter on a time hierarchy, the level of the data being returned from the server is not restricted to the level of the hierarchical filter. Which means you are able to drill up to the highest level including "All". That's why that "All" is always shown. But Chart and Table filters are limit to the specific level which you select. And you can only drill down, but cannot drill up to the higher level than the selected one. For example, when you select a Quarter, you will see the highest hierarchy level as Quarter, you can only drill down to lower level, Month, but cannot drill up to Year. In this case, all the higher level hierarchy will not be shown. This is the different behaviour between Story/Page filter and Chart/Table filter.

Resolution

An enhancement request is open in Influence Customer site:

https://influence.sap.com/sap/ino/#/idea/202085

See Also

 

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, 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 Predictive , Problem

Product

SAP Analytics Cloud 1.0