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'] |