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

Data Analyzer URL Parameter

Rui_Varela
Product and Topic Expert
Product and Topic Expert
0 Likes
5,454

Hi SAC experts,

I would like to know if it's possible to pass filters to Data Analyzer from an Analytical Application. I'm using the NavigationUtils.openDataAnalyzer API but without success.The model is the same in AA and DA but believe doesn't matter.

I know how to pass filter values from AA to a Story and AA to AA but even simple parameter such as embed mode as been difficult.

Below one example of my code, I have tried only 1st parameter, only 2nd parameter and both parameters.

NavigationUtils.openDataAnalyzer('&/dz/9102B879DBA6EE5C878C23D8A9E21EF',undefined,[UrlParameter.create("Country/Region","Germany"),UrlParameter.create("mode","embed")]);

Also, is there any documentation of URL API for Data Analyzer? like this one for Story SAP Analytics Cloud URL API

The behavior I want to replicate is the one we get when we open a Data Analyzer from a table in the new Optimized Design Experience Story, where the filter values are passed to the Data Analyzer (Image attached).

Thank you for your time.

View Entire Topic
N1kh1l
Active Contributor
0 Likes

ruivarela

I haven't tested the url parameters ( for filtering ) but to just open the data analyzer from analytic application/stories 2.0 on button click, you can use the below . This is based on the same model my story was.
NavigationUtils.openDataAnalyzer("&/dz/?dataSourceName=t.2Q.Ct504e17qcsmrfon929702t8a4o:Ct504e17qcsmrfon929702t8a4o&systemType=MODEL");

On Button click

Hope this helps !!

Nikhil

Rui_Varela
Product and Topic Expert
Product and Topic Expert
0 Likes

Thank you for your comment Nikhil,

The Data Analyzer was previously build because I want to sort and show the Dimensions in a specific way different from table layout. The table is hidden to the user tat's why I need to pass filter values from AA to DA.

Thank you again!

N1kh1l
Active Contributor
0 Likes

ruivarela

I have been trying to pass url parameters but without success to Data Analyzer. I have tried the below but it does not work.

NavigationUtils.openDataAnalyzer(undefined,"&/dz/?dataSourceName=t.2Q.Ct504e17qcsmrfon929702t8a4o:Ct504e17qcsmrfon929702t8a4o&systemType=MODEL",[UrlParameter.create("f01Dim","Date"),UrlParameter.create("f01Val","20231")]);
Please revert if you manage to pass the parameters successfully.Nikhil
chickman1972
Explorer
0 Likes

Have you tried adding the Op parameter?

Also, i'm not sure your connection and data source parameters are correct. Try updating your call with this but ensure that the first parameter is the name of your connection and the second parameter is the name of your model:

NavigationUtils.openDataAnalyzer("ConnName","ModelName",[UrlParameter.create("f01Dim","Date"),UrlParameter.create("f01Val","20231"),UrlParameter.create("f01Op","in")],true);