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
- 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.
- Go to the bin folder in the PlatformAnalytics directory.
- Run the platform-analytics-data-cleanup script. Make sure to enter the full path of the text file as the input parameter.
- Open the corresponding log file to confirm the number of deletions.
- If necessary, go to the Platform Analytics repository to confirm the deletions.
Copy
platform-analytics-data-cleanup.ps1 -f C:\Users\mstr\Desktop\YourTextFile.txt
How to Delete User Data in Linux
- 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.
- Go to the bin folder in the PlatformAnalytics directory.
- 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
-
Run the corresponding log file to confirm the number of deletions.
Copytail -f ../log/platform-analytics-data-cleanup.log
- You can also go to your Platform Analytics repository to confirm the deletions.