SAP Knowledge Base Article - Public

3254803 - Delete facts option in a model not respecting data access control delete column setting in SAP Analytics Cloud (SAC)

Symptom

The delete facts option in a model does not respect the data access control (DAC) delete column setting in SAP Analytics Cloud (SAC).

Environment

  • SAP Analytics Cloud (Enterprise)

Cause

  • The delete permission for a member of the Version dimension refers to the deletion of the dimension member itself and not to the underlying fact data.
  • Fact data deletion is controlled by the "maintain" privilege which covers data changes and there is no differentiation between setting a value to zero or deleting it.
  • If a user has write access to a dimension member via DAC, then that user will be able to update the fact data for that dimension by entering a zero (0), clearing the data in the table and publishing it, or going into the model and selecting the delete facts option.

Resolution

Working as designed.

See the following help pages and knowledge base articles for further information:

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, sac hot news sac kba sap analyst cloud, Planning user with Planning reporter role is able to delete facts in the model directly for all companies or versions access to write enabled  , KBA , LOD-ANA-ML , SAC Modelling , LOD-ANA-ADM , SAC Administration , LOD-ANA-PL-VER , Version Management , Problem

Product

SAP Analytics Cloud 1.0