Question Re: SAC Application script, chart onselect value passing... in Technology Q&A

SAC Application script, chart onselect value passing into url parameter

kiran_s611 — Sat, 27 Sep 2025 10:31:43 GMT

Hi All,

I am trying to capture the selected dimension value from a chart. This value i am trying to pass into URL parameter to child report.
Value is getting passed to child report but data is not getting filtered.

I have created script variable "RegionFilter" both in parent report and child report.

When i am passign the parameter value from a Dropdown or Check box, data is getting filter in child report, but with chart it is not working.
Parent report parameter passing url :-

NavigationUtils.openStory("9E218282F57BE2D4EBBC6959FE0D0AB1", "a31b3cd2-f023-4b22-ac46-3e90b81c8e7a",
[UrlParameter.create("p_RegionFilter",CB_Country.getSelectedKeys().join("|")),UrlParameter.create("p_MaterialFilter",List_Material.getSelectedKeys().join("|"))]);

Child report logic to apply filter :-

RegionFilter;

console.log(RegionFilter);

if (RegionFilter==="ALL") {

console.log(RegionFilter);

Table_1.getDataSource().removeDimensionFilter("Country");

}

else if (RegionFilter!=="ALL") {

console.log("Chart selected value ... "+ RegionFilter);

Table_1.getDataSource().setDimensionFilter("Country",RegionFilter.split("|"));

}

Can anyone of you please help me in this.
Thanks,
Subash

Re: SAC Application script, chart onselect value passing...

N1kh1l — Mon, 29 Sep 2025 11:54:19 GMT

@kiran_s611

Table_1.getDataSource().setDimensionFilter expects either a string or an array of string members as parameters. Please ensure when you are passing you are respecting the format.

When you read values from chart selection they might not be in the correct format as expected by the API. The below blog will help you.

https://community.sap.com/t5/technology-blog-posts-by-members/sac-analytic-application-reusable-script-function-for-linked-analysis/ba-p/13440856

Nikhil

Re: SAC Application script, chart onselect value passing...

kiran_s611 — Fri, 03 Oct 2025 14:04:50 GMT

Hi @N1kh1l ,
Thanks for your suggestion. By going through the link suggested by you i have tried with the below code, which worked for me.

Thanks for your help.

Re: SAC Application script, chart onselect value passing...

kiran_s611 — Fri, 03 Oct 2025 14:01:46 GMT

Hi Nikhil

Re: SAC Application script, chart onselect value passing...

N1kh1l — Fri, 03 Oct 2025 15:50:30 GMT

Kiran, I am glad it worked for you. Could you please close the thread by accepting the answer so that i can be helpful to others.