2024 May 05 9:43 PM - edited 2024 May 06 10:41 AM
Hi SAP community,
I want a data action to be trigged when I assign hours to an employee.
In this case I want to assign hours worked by an employee to a measure "AssignHours" on a date chosen by the user.
This is the data action code:
The Data is in the format YYYY-MM-DD and the parameter input is a string.
When I replace MEMBERSET [d/Date] = %Date% with MEMBERSET [d/Date] = "2024-01-01" (meaning hard code the date), it works and assigned the hours to the measure.
However, as I am calling the data action in a responsive story page, when I hard code this into the pulled parameter shown below it does not assign the hours to the measure.
Even though the parameters are accepted by the Data Action (no issues detected in Data Action Monitor), the data action fails to trigger and gives the following error:
There are validation errors in the data action when trying to run it on version "Actual"
Can you assist with issue I am having.
Request clarification before answering.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, you said that the data action works when you hardcode the Date parameter like this MEMBERSET [d/Date] = "2024-01-01". What's the Date parameter in the data action monitor when hardcoded?
It looks like a time hierarchy problem. Maybe the date format that the data action is expecting is not correct.
Try creating a table with date dimension and see what's the date format like shown in this video starting at min 08:00
https://youtu.be/Sy2on6IFP6A?si=uvIUvPW-B4NQ_9l0&t=435
User | Count |
---|---|
58 | |
10 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.