This discussion is archived
1 Reply Latest reply: Nov 24, 2012 3:25 AM by Nasar RSS

doubt in calculated measure in awm

saranya.a Newbie
Currently Being Moderated
i have the below dimensions: cluster dimension,destination location dimension,origination location dimension,destination ip dimension,origination ip dimension, date dimension and measure : call duration.

for example consider the below sample data..
cluster -c1
destination location - L1
origination location - L2
destination ip - 10.103.23.45
origination ip - 11.23.45.67
duration - 20

cluster -c2
destination location - L2
origination location - L3
destination ip - 10.1.23.87
origination ip - 13.65.78.90
duration-30

Now i need to calculate the percentage call duraion across cluster c1,destination location-L1,origination location-L2, destination ip-10.103.23.45 and origination ip-11.23.45.67----
so i should get as below--(duration across the above criteria/total duration)*100 ie., (20/20+30)*100.
but the issue am facing is, in awm for the denominator am getting the total duration as 20 itself instead of 20+30. the entire duration is not getting added. how do i get the entire duration? since i have 3 dimensions to be considered, i dont know how to use share measure.

i need to calclutate the total duration. can anyone pls help me out??
  • 1. Re: doubt in calculated measure in awm
    Nasar Journeyer
    Currently Being Moderated
    http://docs.oracle.com/cd/E11882_01/olap.112/e17123/calculations.htm#CIHJGEJA
    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)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points