MicroStrategy ONE

Delete User Data

You can delete data for specific users, across all tables in the Platform Analytics warehouse, by running the data cleanup script.

How to Delete User Data in Windows

  1. Create a text file with the login IDs or email addresses of the users whose data you want to delete. There should only be one login ID or email address per line.
  2. Go to the bin folder in the PlatformAnalytics directory.
  3. Run the platform-analytics-data-cleanup script. Make sure to enter the full path of the text file as the input parameter.
  4. Copy
    platform-analytics-data-cleanup.ps1 -f C:\Users\mstr\Desktop\YourTextFile.txt

  5. Open the corresponding log file to confirm the number of deletions.
  6. If necessary, go to the Platform Analytics repository to confirm the deletions.

How to Delete User Data in Linux

  1. Create a text file with the login IDs or email addresses of the users whose data you want to delete. There should only be one login ID or email address per line.
  2. Go to the bin folder in the PlatformAnalytics directory.
  3. Run the platform-analytics-data-cleanup script. Make sure to enter the full path of the text file as the input parameter.
    Copy
    ./platform-analytics-data-cleanup.sh -f /opt/mstr/PlatformAnalytics/bin/YourTextFile.txt
  4. Run the corresponding log file to confirm the number of deletions.

    Copy
    tail -f ../log/platform-analytics-data-cleanup.log
  5. You can also go to your Platform Analytics repository to confirm the deletions.