Question Re: choosing rows/columns from data source to show in Dat... in Technology Q&A

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

abdussamad_peera — Tue, 22 Apr 2025 14:50:05 GMT

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);

Re: choosing rows/columns from data source to show in Dat...

William_Yu1 — Wed, 23 Apr 2025 04:16:03 GMT

One thought:

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

Re: choosing rows/columns from data source to show in Dat...

abdussamad_peera — Wed, 23 Apr 2025 17:50:29 GMT

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?

Re: choosing rows/columns from data source to show in Dat...

William_Yu1 — Thu, 24 Apr 2025 01:39:49 GMT

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

Re: choosing rows/columns from data source to show in Dat...

abdussamad_peera — Thu, 24 Apr 2025 19:19:48 GMT

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!