This content has been marked as final. Show 1 reply
Scroll down for "SHARE" calculation explanation.
Share calculates the ratio of a measure's value for the current dimension member to the value for a related member of the same dimension. You can choose whether the related member is:
Top of hierarchy: Calculates the ratio of each member to the total.+
Member's parent: Calculates the ratio of each member to its parent.+
Member's ancestor at level: Calculates the ratio of each member to its ancestor, that is, a member at a specified level higher in the hierarchy.+
(1). Which dimension do you want to use for SHARE calculation?
(2). In the two records that you are showing, all dimension members are different so on what basis are you saying (20+30)?
(3). Are there parent nodes for each dimension (i.e., Cluster, destination_location, origination_location, destination_ip, origination_ip)