BuddyPress.org

In your child theme (assuming it follows a similar structure to bp-default):

Edit your /activity/index.php file to remove the tab