I'm using SQL server 2008 standard edition.
I have a cube with measure groep sickness, and dimensions date and employee.
In the sickness fact table i have employeeID, sick ID, sick start date, sick end date. The employeeID is linked to employee dimension, and both the sick start date and end date are linked to the date dimension.
Now i want to create a calculated measure, which calculates the sum of the duration of all sick cases that ended in period t.
So that I later can create a report with on one axis the period (months) and on the other axes the sum of the duration of all sick cases ended in that month.
I already have a measure which counts sick duration. But how can I add the condition that it only takes the sick cases ended in a period?
View Complete Post