Ask the Expert

Compression: useful for loading and reporting in BW?

How is compression useful for loading and reporting? When should I compress, and how do I identify that the cube needs to be compressed? Does it have anything to do with the landscape?

    Requires Free Membership to View


BW cubes have mainly two fact tables -- F and E tables. The data is always loaded to the F fact table and the compression process moves the data from the F to the E fact table.

If your F fact table becomes too big, your load process will considerably slow down depending on the volume. Also if the cube is compressed the query performance will improve due to various reasons. It is best to compress the cube every day, keeping only three or four days of non-compressed data.

This was first published in October 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: