Calculate Median in SSAS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Calculate Median in SSAS

Calculate Median in SSAS

Rate Topic

Display Mode

Topic Options

Author

Message

hardikp-1137353

Posted Monday, August 03, 2009 4:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 13, 2009 2:21 AM
Points: 1, Visits: 10

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.

Post #763965

« Prev Topic | Next Topic »

Permissions