Calculate Median in SSAS

• hardikp-1137353

  SSC Journeyman

  Points: 81

  More actions

  August 3, 2009 at 4:09 am

  #140353

  I have created three dimension and one fact table. Schema of those tables are as below:

  Dimension Table1: tblEmployee

  Field Name DataType

  EmployeeID Int (PK, Identity)

  EmployeeName Varchar(100)

  Dimension Table2: tblDesignation

  Field Name DataType

  DesigID Int (PK, Identity)

  DesigName Varchar(100)

  Dimension Table3: tblBranch

  Field Name DataType

  BranchID Int (PK, Identity)

  BranchName Varchar(100)

  Fact Table: tblProject

  Field Name DataType

  ProjectID Int (PK, Identity)

  EmployeeID Int

  BranchID Int

  DesigID Int

  HoursWorked Int

  Now I want to calculate median on field "HoursWorked" from the Fact table.

  Please help me to do that. Please provide steps to resolve the problem.