Not sure how many users you have working on your system and how much data you are consolidating, but 30 GB sounds like a lot for an HFM App. You can drastically affect speed depending on an App's rules, and in my experience, you can get a much bigger performance improvement by improving the rules than by optimizing those settings.

Hi,

I am afraid you have data explosion at HFM which is caused by defects in rule file.

For example, if any rules writes like

Hs.Exp A#10000 = A#120000.I#[ICP Top].C1#ABC.C2#ABC.C3#ABC.C4#ABC

If A#120000.I#[ICP Top].C1#ABC.C2#ABC.C3#ABC.C4#ABC = 100, then this 100 will copied to all the available intersection for account 10000.

However, you may only need to copy this value to one intersection for account 10000.

This is the most possible reason that you have so many data at HFM.

Thanks.

James Zhang