Hyperion 11.1.2.3 - DCE and DCN Tables

All -

We are experiencing significant data growth

Does anybody have a SQL query that gives the ability to pull out not only data by entity and account but by Custom dimension as well.

We started using a 5th custom dimesion and populating its members has contributed to massive database growth.
Several data points that had been created by populating the custom 5 dimension were found to be erroneous.

We are painfully removing the erroneous data but are not seeing a decrease in the data extracts.

for some context

Our HFM database is over 400 Gigabytes

Thanks,
Josh