Home > OLAP Calculation Templates > Simple Math > Index
![]() Previous |
![]() Next |
Calculates the ratio between the values of a measure and a selected value that serves as a base number. Multiplying this fraction by 100 generates the percentage.
Index measure measure for:
Dimension | Member |
---|---|
Dimension | value |
Dimension | value |
Multiply result by 100.
This example defines the value of Desktop PCs in 2006 as the index for Units. The Channel and Customer dimensions default to the most aggregate member (Total).
Index measure UNITS for:
Dimension | Member |
Time | 2006 |
Channel | <none> |
Customer | <none> |
Product | Desktop PCs |
Multiply result by 100.
(GLOBAL.UNITS_CUBE.UNITS / GLOBAL.UNITS_CUBE.UNITS[GLOBAL.TIME = 'CY2006', GLOBAL.PRODUCT = 'DTPC']) * 100
The following table lists Products at the Family level for 2006. Because Desktop PCs is the index, its value of 45,763 units has an index value of 100%. The index values of all other products are calculated in relation to this number.
Product Parent Units Index (%) -------------------- ------ ------- --------- CD/DVD HRD 72304 158 Modems/Fax HRD 52043 114 Desktop PCs HRD 45763 100 Monitors HRD 15738 34 Memory HRD 15478 34 Portable PCs HRD 7897 17 Accessories SFT 270096 590 Operating Systems SFT 77906 170 Documentation SFT 27704 61