I am trying create a Calculated Member in SSAS using the one Fact table and two dimensions but having issues. Below is the sql query I want to use as a
Calculated member in SSA
SELECT COUNT(FacteTMS.TaskKey) AS TaskCount, DimeTMSOrg.Description
FROM FacteTMS INNER JOIN
DimeTMSOrg ON FacteTMS.OrganizationKey = DimeTMSOrg.OrganizationKey INNER JOIN
DimDate ON FacteTMS.CreatedDateKey = DimDate.DateKey
GROUP BY DimeTMSOrg.Description
Fact table--->FacteTMS
Dimensions are 1 ) DimeTMSOrg
2) DimDate