Use the Case Analyzer compression wizard to compress the Case Analyzer store. You can use the Case Analyzer compression wizard only on Microsoft SQL Server databases.
As the fact tables in the Case Analyzer store grow over time, they require more disk space and longer cube-processing times. Compressing the Case Analyzer store reduces the fact table sizes by aggregating, or "rolling up," measures across common dimensional values, with a resulting loss of information.
For example, consider a system that is composed of insurance claim data.
Date | Claim Type (dimension) | Claim Number (dimension) | Workflow count (measure) |
---|---|---|---|
1-2-12 | Homeowners | 18275 | 1 |
1-5-12 | Auto | 67251 | 1 |
1-26-12 | Auto | 36185 | 1 |
2-22-12 | Auto | 47477 | 1 |
4-13-12 | Auto | 92487 | 1 |
4-28-12 | Auto | 37530 | 1 |
5-15-12 | Homeowners | 88357 | 1 |
Compressed by month and claim type, the data is aggregated by month. The precise date and actual claim number information is lost.
Date | Claim Type (dimension) | Claim Number (dimension) | Workflow count (measure) |
---|---|---|---|
Jan 2012 | Homeowners | <unknown> | 1 |
Jan 2012 | Auto | <unknown> | 2 |
Feb 2012 | Auto | <unknown> | 1 |
April 2012 | Auto | <unknown> | 2 |
May 2012 | Homeowners | <unknown> | 1 |