At Sales Reports documentation page see Allowed Values Based on Sales Report Type paragraph which contains valid combination of parameters per report type. Here you can see that for SUBSCRIPTION_EVENT the only valid frequency is DAILY, so this is the issue in your case. And API just returns incorrect error, while it should rather state that specified frequency is incorrect for this report type.