cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Passing the DIMENSION ID of an Associated Dimension as URL parameter

ramanathank
Discoverer
0 Kudos
297

Dear Experts,

I am trying to call/open  report using scripting. I used use the onselect event of the table and checked if user selected a particular dimension if he did I called using

 

NavigationUtils.openStory("DD6FC70093DC25R3456655553384E1F5", "a31b2345-f033-4b42-ac46-3eeff8891c8e7a",[UrlParameter.create('mode','view'),UrlParameter.create('f01Model','t.2.Cvlrse0adfdfdafafdtj57v2g:Cvlrse04jrt2cfarc2h4tj57v2g'),UrlParameter.create('f01Dim','CLIENT_CODE1'),UrlParameter.create('f01Val',member),UrlParameter.create('f01Op','in')],true);

It generated all URL similar to below

https://XYZ-q.ap11.hcs.cloud.sap/sap/fpa/ui/tenants/f9907/app.html#/story2&/s2/DD6FC70093DC259538487... 

This gave me an error

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/0c84d524ee1c4b88836287579...

 

In model I have the CLIENT_CODE is used twice through two associations CLIENT and PARENT CLIENT

CLIENT_CODE1 and CLIENT_CODE are the respective Technical names of the Fields. But I am unable to filter on both. But I use another which is directly available in Fact Table like SALES_DATE i able to pass it as parameter..

Is there a different way to reference Dimensions of an association. Please help me as how to find the exact reference to the dimension from the association.

 

Thanks lot for your help folks.

Regards

Ram

 

Accepted Solutions (0)

Answers (0)