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.