SYMPTOM:
In Strategy Command Manager 9.x and 10.x, the PURGE STATISTICS command does not delete the following tables:
IS_MESSAGE_STATS,
IS_CUBE_REP_STATS
IS_INBOX_ACT_STATS
CT_MANIP_STATS
CT_EXEC_STATS
CT_DEVICE_STATS
CAUSE:
This is a known issue with Strategy 9.x and 10.x.
ACTION:
Currently this issue is being reviewed by Strategy for a potential code fix on an upcoming Strategy release.
WORKAROUND:
Purge statistics using Server/Project Configuration or Schedule Administration Tasks.
Refer to following Technical Notes for more detailed steps:
KB11295: Different levels of purging Statistics data in MicroStrategy Intelligence Server 9.x
KB20617: How to schedule purging of Statistics in MicroStrategy Intelligence Server 9.x
