SAP Knowledge Base Article - Public

3507642 - Ability to define URL API to filter on time and non-default Parent child Hierarchies in Optimized Design Experience (ODE) mode story based on live data connection to BW models in SAP Analytics Cloud (SAC)

Symptom

  • The SAP Analytics Cloud URL API now allows story designers to filter on time and Parent child Hierarchies which are not default for BW Live Data connections

Environment

  • SAP Analytics Cloud (Enterprise) 2024.15

Resolution

  • Since 2024 QRC3, story designers are able to define URL API to filter on time and non-default Parent child Hierarchies in Optimized Design Experience (ODE) mode story based on live data connection to BW models.
  •  "f(XX)Hierarchy" parameter supports to filter on time and parent-child hierarchies with different hierarchal values.  
  • This functionality allows developers to generate URLs for stories with embedded hierarchy node filters.
  • Parameter Syntax: f<XX>Hierarchy=<HierarchyName> 
    • <XX> is any number between 01 and 99. If there are several filters passed for filtering then assign a unique value of <XX> to each filter. <HierarchyName> is the name of the hierarchy you want to filter on.
  • This is only supported in the Optimized Story Experience.
  • For detailed information, please refer to help document Filter Parameters | SAP Help Portal and blog What’s New in SAP Analytics Cloud Release 2024.13 - SAP Community.

See Also

Keywords

sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, Story, story, Stories, stories, Story 2.0, story 2.0, Optimized Design Experience mode, ODE, ode, Optimized View mode, OVM, ovm, enhancement, filter, hierarchy, BW, default, URL, API, open document, link, time , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0