SAP Knowledge Base Article - Public

2604200 - How to remove partial data from a model in SAP Analytics Cloud

Symptom

You are regularly importing data to a BI model or working with a planning model and want to clear older data, for example anything from last year.

Environment

  • SAP Analytics Cloud

Resolution

You can use Version dimention and set filters for Actual.

  1. Go to the Models - Main Menu > Browse > Models
  2. Select the check box beside a model.
  3. Select the icon eraser (delete facts) 
  4. Select the members that you want to clear.

You can select members from one dimension, then switch to other dimensions and select members of those dimensions. For example, to delete only the data actuals from 2013 and 2014, select the Version dimension, set the filter to Actual, and then select the Time dimension and set the filter to 2013 and 2014.

Note:
You can delete only members for which you have write access. For example, if you have write access only for version Plan, and you don't set a filter, then only the data facts for version Plan will be deleted.

See Also

Keywords

purge, clean, erase, last year, year, older, old, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , How To

Product

SAP Analytics Cloud 1.0