Skip Headers
Previous
Previous
 
Next
Next

Share

Calculates the ratio of the value of the current dimension member to the value of a selected member. Multiplying this fraction by 100 generates the percentage.

Template

Share of measure measure (...) in hierarchy hierarchy of the dimension dimension as a ratio of { top of hierarchy | member's parent | ancestor at level level | member (...) }.

Multiply result by 100.

Example

This calculated measure computes the percentage that each customer contributes to its parent in the Units measure.

Calculation

Share of measure UNITS in CUSTOMER_MARKET hierarchy of the CUSTOMER dimension as a ratio of member's parent.

Multiply result by 100.

OLAP Expression Syntax

(SHARE(UNITS_CUBE.UNITS OF CUSTOMER.MARKET PARENT)) * 100

Query Results

The Pct Share column shows the percentage that each market segment contributes to the total number of units sold.

Customer             Parent   Units Pct Share
-------------------- ------ ------- ---------
Reseller             TOTAL   304415        54
Consulting           TOTAL   250931        44
Government           TOTAL     5756         1
Manufacturing        TOTAL     4121         1
Education            TOTAL      495         0
Total Customer       null    565718       100