choosing rows/columns from data source to show in Data Analyzer using a script from story

[abdussamad_peera]

Hi Folks,

I know you can call the data analyzer from the story and it works fine but how can I specify dimensions and measure for the columns and rows programmatically.  Right now, I have to manually select them once the DA opens.  I know I can call pre-built insight but there you cannot pass parameters.  Both options have limitations.  I am calling DA when user clicks on a product on a chart.  I do not want to build out all rows and columns in a table in the story as it is a lot of data and slowing down the story performance.  Appreciate the help.

NavigationUtils.openDataAnalyzer("HANACLOUD",
"[Schema_HDI_DB_1][Pkg_HDI_DB_1][view_name]",
[ UrlParameter.create("connectionType", "HANACLOUD"),
UrlParameter.create("systemType", "HANA"),
UrlParameter.create("f01Dim","Product Description"), // filter name
UrlParameter.create("f01Val",result),   //filter value

UrlParameter.create("f01Op","in")], true);

[William_Yu]

One thought:

1. create a dummy/hidden table
2. set dimension to row/column on this table via JS API,
3. Launch data analyzer via API. table.openDataAnalyzer()

[abdussamad_peera]

Hey William, thanks for your response. Let me see if I understand this correctly. If I have this dummy table pulling data in the story from the backend source even though it's hidden, will it not impact the page performance. Let me know if I missing a point here. Could you please expand on this?

[William_Yu]

That's right, hidden table should not impact story performance, but you need to test it out anyway.

[abdussamad_peera]

It turns out that I can pass parameters using pre-built DA report. However, if I am using a chart that is based on an input control for dimension, I am unable to parse the selected value as it is not supported. bummer!