Symptom
f<XX>hierarchy parameter cannot work as expected when the story is based on a live Datasphere model in SAP Analytics Cloud
Environment
SAP Analytics Cloud 2025.01
Reproducing the Issue
- Prepare a Datasphere model with dimension which contains hierarchy
- Log in to SAP Analytics Cloud
- Create a story based on the live Datasphere model and save this story
- Using f<xx>hierarchy parameter in story URL and try to open this story with a filter to filter the hierarchy data.
- Find that the hierarchy filter cannot be created, or created but the filter value is not passed.
Cause
In this special case the hierarchy defined in datasphere is Level Based Hierarchy. The development team has confirmed that the URL API in current product doesn't support to pass value to this kind of Level Based Hierarchy.
Resolution
This is a product limitation. Please consider to not use hierarchy as the parameter but use the flat value, which is passed by the URL API.
See Also
Keywords
SAP Analytics Cloud, Story Navigation, UrlParameter.create, NavigationUtils.openStory(), Datasphere live connection, URL parameters, hierarchy, filter, Data Access Language, Japanese, English. , KBA , LOD-ANA-DES-URLAPI , SAP Analytics Cloud Story related URL parameters API , Problem