OLAP Formula

• ksurya

  Valued Member

  Points: 52

  More actions

  December 4, 2003 at 2:15 pm

  #107017

  I would like to calculate Median on some population (No of Day to Approve an application)

  Here is the formula I wrote

  X = "Median({[Time].Currentmember},[Measures].[Time To Approval])"

  "[Time To Approval]"-Is a Measuere defined in the cube.

  However, When I execute the OLAP cube and browse data, Formula is not calculating corrently.

  Value of X is same as [Time to approval] value.

  Any Suggestions, Kindly advise

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  December 8, 2003 at 4:20 pm

  #485209

  You're using a set of only one member for the first parameter of the Median function, so the median is the value you have passed in.

  HTH,

  Steve.

  Steve.