SAP Knowledge Base Article - Public

2621717 - Filters applied on a hierarchical dimension to an open story URL does not work in SAP Analytics Cloud (SAC)

Symptom

  • After applying a filter on a hierarchical dimension via an open story URL, the filter automatically created to the first hierarchy.
  • There are multiple hierarchies for the dimension.
  • The filter value in the url belongs to the second hierarchy, however it gets applied to the first, so the following error message appears: "No data is available for the chart to render."

Environment

SAP Analytics Cloud 2018.4.1

Reproducing the Issue

  1. Create an SAP Analytics Cloud Story.
  2. Define and open an open story URL, as per Filter Parameters.
    For Example: "https://<TENANT>/sap/fpa/ui/tenants/<TENANT_ID>/bo/story/<STORY_ID>?f01Model=<MODEL_ID>&f01Dim=<DIM_ID>&f01Val=<Value from HIER2>"
  3. Notice the error and the wrong filter.

Cause

Currently we only support filtering on default hierarchy in our Story URL API. The filter is applied on the first hierarchy, while the filter value belongs to another hierarchy.

Resolution

Supporting other hierarchies requires an enhancement of our product. Please raise this idea on our Customer Inflience site.

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

EPM, 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, API, incorrect, hier, URL, filter parameters, filter, hierarchy, members, nodes, leaf, first , 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