Symptom
- The API Table_1.getPlanning().getDataLocking().getState() returns undefined in console.
- The error message "Data cell is not found" is displayed.
Environment
SAP Analytics Cloud, Analytics Designer
Reproducing the Issue
- Use the API Table_1.getPlanning().getDataLocking().getState() in script.
- Observe that the API does not work properly if the hierarchy is not unfolded.
Cause
The issue arises when the Date hierarchy is not fully unfolded, causing no data cell to be displayed. The API cannot find the corresponding data cells, and as a result, it returns undefined.
Resolution
- Ensure that the Date hierarchy is fully unfolded to display all data cells.
- Use the API to check the data lock status.
See Also
Refer to the API details in the guide: http://help.sap.com/doc/958d4c11261f42e992e8d01a4c0dde25/release/en-US/index.html#DataLocking_MgetState
Keywords
SAP Analytics Cloud, API, Data Lock Status, Date Hierarchy, Data Cell, Undefined , KBA , LOD-ANA-AD , Analytics Designer , Problem
Product
SAP Analytics Cloud all versions
SAP Knowledge Base Article - Public