Question Re: How to send parameter values to SAC Data Action throu... in Technology Q&A

How to send parameter values to SAC Data Action through Scripting

Vasu_Sac — Mon, 02 Jun 2025 14:44:45 GMT

How to send parameter values to SAC Data Action from Story Filters.

I have updated parameters with fixed values in script for data action and it is working, But I am looking to get user selected values from Story Filter to pass DA parameters instead of hard coded values.

How to get user selected values from Story filter and pass to DA parameters.

Story Filters:

Please help. Regards, Vasu

Re: How to send parameter values to SAC Data Action throu...

William_Yu1 — Tue, 03 Jun 2025 04:12:54 GMT

You check this script API to get dimension

var filter = Application.getFileDataSource(modelID).getDimensionFilters(dimensinonID);

Re: How to send parameter values to SAC Data Action throu...

Vasu_Sac — Tue, 03 Jun 2025 12:39:29 GMT

Hi @William_Yu1

Thanks for your reply.

I have updated below code and getting error while passing the variable value filter_C to setparameterValue function. If I use double or single quotes, the variable is not recognizing. If I remove quotes, its giving below error.

Application.showBusyIndicator(" DA Executing..."); var filter_CC= Application.getFileDataSource("xxxxxxxxxxxxxxxxxxxxx").getDimensionFilters("CompCode")[0]; switch (filter_CC.type){ case FilterValueType.Single: var filter_C = cast(Type.SingleFilterValue, filter_CC); console.log(filter_C.value); break;} DataAction_1.setParameterValue("FYMonth_Input",'[Date].[FYP].&[202501]'); //DataAction_1.setParameterValue("CCODE_Input","100"); DataAction_1.setParameterValue("CCODE_Input",filter_C); DataAction_1.setParameterValue("SalesGroup","SG1"); DataAction_1.execute(); Application.refreshData(); Application.hideBusyIndicator();

Re: How to send parameter values to SAC Data Action throu...

William_Yu1 — Tue, 03 Jun 2025 12:52:13 GMT

I think the parameter you sent is having different type as can be accepted by data action. You need to convert it first.

You may check the example with section 5.35.3.1 of below help doc.

https://d.dam.sap.com/a/3Y16uka/DeveloperHandbookSACAnalyticsDesigner.pdf

Re: How to send parameter values to SAC Data Action throu...

Ajit5 — Wed, 04 Jun 2025 22:14:30 GMT

If the data action is being triggered via a story, you can pass the story filter through the Builder panel under the Parameters section.