SAP Knowledge Base Article - Public

2666715 - The filter window keeps loading when trying to create a Date Range filter in a Story using a live HANA model in SAP Analytics Cloud (SAC)

Symptom

  • The filter window keeps loading when trying to create a Date Range filter in a Story using a live HANA model in SAP Analytics Cloud (SAC).
  • The following error message appears in the Google developer tool console:
    " Error: invalid hierarchy depth"
  • The time hierarchy selected for the range filter contains both month and week level.

Environment

  • SAP Analytics Cloud 2018.12.1
  • SAP HANA
  • SAP HANA Cloud Platform

Reproducing the Issue

  1. Logon to SAC.
  2. Create a new Story using a live HANA model.
  3. Create a range filter using a time hierarchy contains both month and week level.
  4. Notice that the range filter window keeps loading and the error in the console.

Cause

  • The used time hierarchy is not supported.

Resolution

  • Use a fully supported date hierarchy.
  • Fully supported date hierarchies are can be found here.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

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 Predictive , Problem

Product

SAP Analytics Cloud 1.0