 |
|  |
 |
|  |  | |
For example, following a linear scale with a granularity of $0.01, there will be 100,000 records in the rate dimension to encompass all rates up to $1,000. This approach will allow the most accurate analysis but cube performance will fall outside of acceptable parameters. Following a linear scale with a granularity of $1.00, there will be only 1,000 records in the rate dimension to encompass all rates up to $1,000. This approach will allow the fastest cube performance however the analysis for the lower rates will be rounded excessively. If, for example we use $.01 increments up to $10, $.10 increments up to $100 and $1 increments up to $1000, there will be only 2,800 records in the rate dimension to encompass all rates up to $1,000. Using a pseudo logarithmic rate card dimension provides a high level of accuracy in analyzing rate card rates while at the same time staying within acceptable cube performance parameters.
BIAnalytix is an advanced Data Warehouse and Business intelligence system that provides calculated measures defined for efficient and fast presentation of the aggregated values.
| |
|
|
