Creating accelerators
Note: We recommend that you do not create accelerators except to maintain backward
compatibility with existing data sources in which accelerators are used.
Accelerators instruct the OLAP database not to calculate rules that return a zero value. This was sometimes used in previous versions to optimize performance but is no longer necessary.
For example, this rule should not be calculated if Revenue, Discounts, or SD are all zero:
[MEASURE:'Net Revenue']=[MEASURE:'Revenue']-[MEASURE:'Discounts']-[MEASURE:'SD']
To prevent calculation with accelerators would require these three accelerators:
Target | Source |
---|---|
[MEASURE:'Net
Revenue'] |
[MEASURE:'Revenue'] |
[MEASURE:'Net
Revenue'] |
[MEASURE:'Discounts'] |
[MEASURE:'Net
Revenue'] |
[MEASURE:'SD'] |