Data action validation error due to data access control in SAP Analytics cloud

[brahmareddy_kolli]

Hi Experts,

Costcenter is enabled for data access control. 

If user having all costcenters access, i didnot see any data action validation error, but if the user having the one costcenter access then i am getting validation error. Below is my data action format.

how to overcome from this issue

Data action

memberset costcenter =%costcenter%

If cost center = A then 

1+2+3

ENDIF

IF COSTCENTER = B THEN

4+5+6

ENDIF

IF COSTCENTER = C THEN

7+8+9

ENDELSE

[stacey45]

---

@brahmareddy_kolli wrote:

Hi Experts,

Costcenter is enabled for data access control. 

If user having all costcenters access, i didnot see any data action validation error, but if the user having the one costcenter access then i am getting validation error. Below is my data action format.

how to overcome from this issue

Data action

memberset costcenter =%costcenter%

If cost center = A then 

1+2+3

ENDIF

IF COSTCENTER = B THEN

4+5+6

ENDIF

IF COSTCENTER = C THEN

7+8+9

ENDELSE

---

To address the data action validation error when a user has access to multiple cost centers, consider iterating over the costcenter set or using dynamic SQL to filter data based on the specific cost center. Ensure data action security is correctly configured to restrict access to sensitive data. Optimize the data action for performance and implement error handling for robustness.