cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Error in Data Action after activate Data Access Control in a Dimension

0 Likes
979

I developed a Story using the SAP Analytic Application, which included a Data Action where I passed some parameters. Everything was working fine until I added Data Access Control to the model. After adding Data Access Control to the project model and running the Data Action again, the calculation stopped working with this error There are validation errors in the data action "XXX" when trying to run it on version "Actual".
Does anyone know how to solve this issue or have any guidance on how Data Access Control might be affecting the Data Action in SAP Analytics Application?
PS: the data action has been validated successfully.
Error:

Private_Member_740375_1-1737665216871.png

Setting Parameter:

Private_Member_740375_2-1737665423164.png

Thanks in advance

 

 

 

 

Accepted Solutions (1)

Accepted Solutions (1)

0 Likes

Thanks for the answers, we managed to solve it by applying a delay before executing the data action in the application, using the Timer function of the analytical application.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/142a436d0f2a4e97a9af1...

Answers (3)

Answers (3)

Yogeshwar_M
Active Participant

 

Hi @Private_Member_740375 

If your model has validation rule. If you have do calculations through DA it might be throwing error if it doesn't have proper combination of dimension and property.

Also check data locking in model this also showing error

as you mentioned in another story run properly it shows value however while publish data it will shows error.

Kindly upvote if you find it helpful

Thanks

 

N1kh1l
Active Contributor

@Private_Member_740375 

Could you check if hide parent option is enabled for the dimension for which the DAC is enabled. Try running the DA by switching the hide parent off and see if it runs. 

 

Nikhil

0 Likes
Hi, Nikhil. Hide parent was already disabled, but I tried to enable and run it but without success. One point I forgot to mention is that when I run it outside the analytic application via data action trigger, the calculation is executed successfull
William_Yu1
Product and Topic Expert
Product and Topic Expert

Seems your DAC is added to version dimension and user who trigger this data action has no write access to Actual version. You should either grant user with write access to Actual version or just remove DAC on version dimension. 

0 Likes

Hello William, DAC is activated only in the project and company dimensions, and the error occurs for all users including admins.

William_Yu1
Product and Topic Expert
Product and Topic Expert
ok, but you still need to check what authorization user has and how the data action is defined.