Symptom
When using Advanced filtering for cost centers that have a specific flag from master data, the native tools in SAC cannot properly display data locking in the table.
Environment
SAP ANALYTICS CLOUD
Reproducing the Issue
- Open Analytic application/story
- In the edit mode go to the properties of the tables (any of them on the page) and and under Show/Hide section Data locks which were enabled are now greyed out with following message: "To show data locking information, unsupported filters need to be removed: Advanced Filters"
Cause
This is a limitation in the data locks.
Resolution
Advanced filters, particularly non-Cartesian Advanced filters, are not supported for displaying data locking icons and setting data locking-based input enablement in the story.
There is already an enhancement request about this limitation: https://influence.sap.com/sap/ino/#/idea/289840
**Additional Remarks**
- The data locks validation on publish is not affected by this limitation. All changes made to locked data will be rejected as expected.
- Users can enable Data Locking-based Data Disaggregation in the model and on the table widget. Although the input enablement flags indicating whether a cell is editable or not will still be missing, an error message will appear if data is entered into a locked cell, preventing it. This ensures that no data is written in locked areas and cannot be published later, even though the user experience will differ from when Advanced Filters are not present.
- Removing this limitation is on the roadmap, but a timeline for its completion cannot be provided at this stage.
See Also
- https://influence.sap.com/sap/ino/#/idea/289840
- Configuring Data Locking
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, Data lock, advanced filters, non-Cartesian Advanced filters, , KBA , LOD-ANA-PL-DLK , Data Locking , Product Enhancement