SAP Knowledge Base Article - Public

3467024 - "The selected file is used by other files and cannot be deleted." is displayed when trying to delete a model in SAP Analytics Cloud

Symptom

While trying to delete a model, the following alert is displayed and it does not allow the model to be deleted:

  • The selected file is used by other files and cannot be deleted.

The listed files have no relation to the model.

Environment

SAP Analytics Cloud (Enterprise) 2024.2.21

Reproducing the Issue

  1. Logon to SAP Analytics Cloud.
  2. From the main menu, go to Files and search for the model you would like to delete.
  3. Select the model and click on the "Delete" icon.
  4. A window displays an Alert containing the message: "The selected file is used by other files and cannot be deleted.". It also lists the Data Actions files where the model is being used.
    However, the displayed files have no relation to the model.

Cause

The issue happens when switching the default cube of a Data Action, especially for script steps that once had been started with visual formulas.

    Resolution

    1. Create new script steps for each existing script step within the Data Actions listed.
    2. Copy the script-text over to the new script steps created and delete the old steps.
    3. Re-save the Data Action.

    See Also

    Keywords

    SAP Analytics Cloud. SAC, Files, Model, Delete, Alert, not able, can not, Data Action, not possible,  "The selected file is used by other files and cannot be deleted.", relation, related.

    , KBA , LOD-ANA-PL-DA , Data Actions , Problem

    Product

    SAP Analytics Cloud 1.0