SAP Analytics Cloud Planning: Reading Dimension Values Using Script

[#1]

Hello,

Requirement: We need to retrieve the corresponding Dimension value from the row and Period value from the column whenever a cell value is changed.

For example, in the screenshot, if a user enters 10 in a cell, I need to capture the Dimension value "PQR" from the row and the Period value "202602" from the column using a script.

Could someone please help me with the scripting approach to achieve this?

[N1kh1l]

@Manjunath9 

You can use onAfterDataEntryProcess() event of the Table widget to achieve this.

Refer to the below blog to get some help on your requirement.

https://community.sap.com/t5/technology-blog-posts-by-sap/the-onafterdataentryprocess-event-in-sap-a...

Hope this helps !

Nikhil