2877406 - Cannot pass URL parameters to hierarchy nodes in level-based hierarchy in SAP Analytics Cloud (SAC)

The following behavior occurs in SAP Analytics Cloud (SAC):

The SAP Analytics Cloud URL API allows you to directly open stories via a URL. Parameters to apply filters to a story can be added to the open story URL.

You can find more information here: https://help.sap.com/viewer/a4406994704e4af5a8559a640b496468/release/en-US/0c84d524ee1c4b88836287579cae7923.html

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP Analytics Cloud (Enterprise) 2022
• BW live connection
• DWC connection

For example, below story's ID is AAA, it has one table in it which is based on model BBB.

A level-based hierarchy is enabled for the dimension "sub".

If open it with URL:

https://xxx.yy.hcs.cloud/sap/fpa/ui/tenants/001/app.html#;view_id=story;storyId=AAA;f01Model=BBB;f01Dim=sub;f01Val=S1

It works, the filter "sub = S1" is passed.

Now, when try to pass filter "group = G1", open it with URL:

https://xxx.yy.hcs.cloud/sap/fpa/ui/tenants/001/app.html#;view_id=story;storyId=AAA;f01Model=BBB;f01Dim=group;f01Val=G1

Warning "The parameters that were passed to the URL API produced errors." is displayed, and the filter is not passed.

If click "Show More"  in the message box, the details of the warning is displayed:

We detected problems in the URL used to access this story. If you came to this story from a URL you assembled yourself, please resolve the errors below. If you were brought here from a link, please contact your administrator.

There was an invalid dimension ID for filter f01.

Please check that the parameters and values passed to the URL API are well-formed and properly encoded. For more help with the usage of the API, refer to the documentation at:

https://help.sap.com/viewer/a4406994704e4af5a8559a640b496468/release/en-US/0c84d524ee1c4b88836287579cae7923.html

This is a limitation. Currently, this case is not supported.

As a workaround, you can pass the filter on all of leaf nodes. For example,

https://xxx.yy.hcs.cloud/sap/fpa/ui/tenants/001/app.html#;view_id=story;storyId=AAA;f01Model=BBB;f01Dim=sub;f01Val=[%22S1%22,%22S2%22,%22S3%22]

SAC, SAP Analytics Cloud, story,AP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Live, Up, Set, setup, Model, BW,, Story, Working, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap,DWC, BW, filter, link, parameter filter, URL, construct, link dimensions, the filter by URL,We detected problems in the URL used to access this story. , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , LOD-ANA-AD , Analytics Designer , Problem