Question Re: Analytical application button click event error "Script Execution failed for events " in Technology Q&A

Analytical application button click event error "Script Execution failed for events "

zeenat_17 — Tue, 07 Nov 2023 01:34:11 GMT

I had created several landing pages using SAC Analytical Application having Buttons and Data Actions on them.

We completed full budget cycle where we had use all these landing pages and it had been working successfully and for some reason the button click event doesn't work and throws the following error only since yesterday 6th Nov 2023.

Not sure if there were any updates pushed in SAC to cause this issue.

is anyone facing the same issue only recently.

Re: Analytical application button click event error "Script Execution failed for events "

zeenat_17 — Tue, 07 Nov 2023 02:46:21 GMT

Version Dimension

Analytical App (Landing Page).

When the user selects the Version on the filter line , and click on any buttons marked with Red Cross, it passes the Version to the Stories it has to open along with the Date by reading the Start Week and End Week Property as a story filter. but instead these buttons is throwing the error .

Script execution failed for event "Btn_DXxxxx.onClick"

Correlation ID: 15001737-1332-4866-a070-817541167597

where as the one with Blue tick doesn't pass the Version and dates to the story it opens hence the story gets open successfully.

Up until friday 3rd Nov' 23 the Landing page was working fine but it suddenly stopped working.

Can anyone please help.

Re: Analytical application button click event error "Script Execution failed for events "

zeenat_17 — Tue, 07 Nov 2023 02:53:12 GMT

On debugging the script I noticed it started to throw this error.

Re: Analytical application button click event error "Script Execution failed for events "

N1kh1l — Tue, 07 Nov 2023 04:19:26 GMT

zeenat_17

There were updates recently. I would suggest you to raise an incident as this looks like a regression test fail. I noticed something and this might be the case of failure that Reading members of Version dimension in Script API has stopped working. So the below used to work but currently returns blank array and warning saying Version Type dim is not supported.

var sel = PlanningModel_1.getMembers("Version");
console.log(sel);

You can see this was working fine till some weeks back

https://answers.sap.com/questions/13995689/api-to-fetch-a-dimension-member-based-on-property.html?source=email-global-notification-qa-new-in-tag-followed

susannehelbig meganhoy Is this something which was part of the updates ?

Br.

Nikhil

Re: Analytical application button click event error "Script Execution failed for events "

zeenat_17 — Tue, 07 Nov 2023 04:31:29 GMT

thanks Nikhil ,

I have already raised as a high priority issue with SAP and awaiting for their reply.

Regards,

Zeenat S

Re: Analytical application button click event error "Script Execution failed for events "

N1kh1l — Tue, 07 Nov 2023 04:37:53 GMT

zeenat_17

I would request you to update on what response you get from SAP as this could help the community. As this is a common use case, I am sure there will lot of request around this.

Br.

Nikhil

Re: Analytical application button click event error "Script Execution failed for events "

former_member45674 — Wed, 08 Nov 2023 04:06:47 GMT

Hi 2004439259, nikhil_1486,

The Planning model's getMember API only supports generic dimensions. Using it to fetch the Planning Version dimension is an unsupported feature, which is documented in the API document: https://help.sap.com/doc/958d4c11261f42e992e8d01a4c0dde25/release/en-US/index.html#PlanningModel_MgetMember

However, considering the impact on some customers who have been using the API to get the Version dimension, SAP development is working on an urgent fix. Although it is still marked as unsupported, it should work as before.

There are two workarounds to avoid using this unsupported API. Both involve using a hidden table and calling the following API. Remember to turn on the unbooked members for the Version dimension in both cases.

1. Table.getDataSource.getMembers

If you don't need to read the properties of the version, this is the simplest way:

var versions = Table_1.getDataSource().getMembers("Version");
console.log(versions);

2. Table.getDataSource. getResultSet

If you need to read the properties, use this method. Reember to add properties to the table.

var rs = Table_1.getDataSource().getResultSet();
var versions = ArrayUtils.create(Type.string);
for (var i = 0; i < rs.length; i++ ) {
versions.push(rs[i]["Version"].id);
//get properties
//rs[i]["Version"]["properties"]
}
console.log(versions);

I hope this helps.

thanks,

Jason

cc: meganhoy

Re: Analytical application button click event error "Script Execution failed for events "

N1kh1l — Wed, 08 Nov 2023 04:26:48 GMT

jason.yang

Thanks for the update. Aware of the documentation, We took the positive outcome of the getmembers() API of planning model as an improvement of SAC feature list like many other improvements. This API really helped in designing flexible handling of version dimension. Though the alternate method suggested by you do work and we used similar approach before but it requires a hidden table, hence the getmembers() API when worked got adopted. We really hope that SAP development actually fixes the getmember() API of the planning model after all its mostly used in planning use cases. Version is key dimension in planning and lot revolves around version itself.

jefbaey

Br.

Nikhil

Re: Analytical application button click event error "Script Execution failed for events "

JefB — Wed, 08 Nov 2023 09:41:33 GMT

jason.yang Really appreciate the effort trying to get it back working on short term. Will be crossing fingers...

Re: Analytical application button click event error "Script Execution failed for events "

zeenat_17 — Wed, 08 Nov 2023 10:40:36 GMT

Hi Jason,

Thanks for your reply.

Could you please help me to know how should we read the Version Property say "Start Week" and "End Week" from the chart (not table) on the Analytical Application inbound to this Version dimension.

Version to be selected by the user on the Analytical Application (Filter Line) connected to the chart mentioned above.

Regards,

Zeenat S

Re: Analytical application button click event error "Script Execution failed for events "

former_member45674 — Wed, 08 Nov 2023 11:04:40 GMT

Hi 2004439259,

A chart cannot show the "properties of version members." In this case, a table widget should be used.

thanks,

Jason

Re: Analytical application button click event error "Script Execution failed for events "

former_member45674 — Wed, 08 Nov 2023 11:16:10 GMT

Hi jefbaey,

If your tenant is on QRC 4 (version 2023.21), please note that the fix will be included in the next upgrade, which is scheduled for the upcoming weekend. We appreciate your understanding and patience.

thanks,

Jason

Re: Analytical application button click event error "Script Execution failed for events "

former_member45674 — Wed, 08 Nov 2023 11:26:17 GMT

Hi nikhil_1486,

We certainly recognize the importance of this requirement for you. It's on our radar and we will continue to monitor it closely.

thanks,

Jason

Re: Analytical application button click event error "Script Execution failed for events "

N1kh1l — Wed, 08 Nov 2023 11:32:10 GMT

jason.yang

Thanks a lot. Hoping for a positive outcome.

Nikhil

Re: Analytical application button click event error "Script Execution failed for events "

zeenat_17 — Wed, 08 Nov 2023 19:42:28 GMT

hi Jason,

does that mean if our sac tenant version is on QRC 4 (version 2023.21), we do not need to worry about fixing the issue via the work around provided by you anymore. It will be taken care in the next upgrade which is on upcoming weekend?

This is the reply I got from SAP on my incident, please refer the Note highlighted in Yellow. Thanks

Regards,

Zeenat S

hi Jaison,

any comment on my above question please?

Regards,

Zeenat S

Re: Analytical application button click event error "Script Execution failed for events "

zeenat_17 — Wed, 08 Nov 2023 22:36:02 GMT

Jason,

We would really appreciate if SAP can continue to support API to get the Version dimension in particular. Thanks

Regards,

Zeenat S

Re: Analytical application button click event error "Script Execution failed for events "

zeenat_17 — Wed, 08 Nov 2023 23:49:20 GMT

Hi Jason,

Also, the KBA provided on my incident says that we can have a Chart or a table to use this getMembers or GetResult Function but the sample code was only provided for Table.

Re: Analytical application button click event error "Script Execution failed for events "

former_member45674 — Thu, 09 Nov 2023 01:25:04 GMT

Hi zeenat_17,

I have already requested an update to the Knowledge Base Article (KBA) to clarify that a table is required when retrieving properties.

thanks,

Jason

Re: Analytical application button click event error "Script Execution failed for events "

zeenat_17 — Fri, 10 Nov 2023 05:48:20 GMT

Hi Jason,

I am using the Analytical Application page which lets user select the Version and then derives the Date filter by reading the selected Version member properties and then pass it on to the the Stories that it will open on the button click.

I have added the Version dimension and its properties "Start Week" and the "End Week" on the table on Analytical Application page.

and also changed the code as explained, but I could noticed that now the Version dimension selection on the Analytical Application page is letting user to select more than one version dimension member (check box) which is not the right thing and can lead to issues.

we would want only single selection of Version dimension member to be selected. How can we manage/Control it?

Regards,

Zeenat S

Re: Analytical application button click event error "Script Execution failed for events "

former_member45674 — Fri, 10 Nov 2023 06:23:03 GMT

Hi zeenat_17,

I'm not entirely certain I've grasped your question completely. Could you possibly provide more detail? Are you referring to this particular setting?

thanks,

Jason