SAP Knowledge Base Article - Public

2877406 - Cannot pass URL parameters to hierarchy nodes in level-based hierarchy

Symptom

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.
For example, below story's ID is AAA, it has one table in it which is based on model BBB.

21.png

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

23.png

If open it with URL:

https://xxx.sapbusinessobjects.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.

22.png

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

https://xxx.sapbusinessobjects.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.

24.png

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

Environment

SAP BusinessObjects Cloud 1.0

Reproducing the Issue

See Symptom.

Cause

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

Resolution

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

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

Keywords

SAC, SAP Analytics Cloud, story , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , LOD-ANA-AD , Analytics Designer , Problem

Product

SAP Analytics Cloud 1.0