Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Calculate Median in SSAS

Author  Topic  hardikp Starting Member 1 Post Posted - 2009-08-03 : 05:47:51 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. Regards, Hardik Patel