|
isaac.bs
Starting Member
3 Posts |
 Posted - 2008-04-24 : 11:29:17
|
| I have a dimension of Pilots, and a fact table of minutes that each pilot flights every monthposition_id position_desc1, captain2, first officerpilot_id pilot_desc1, pilot12, pilot23, pilot34, pilot4date pilot_id plane_id position_id minutesjan, 1, 100, 1, 9000jan, 2, 200, 1, 8500jan, 3, 200, 2, 10000feb, 1, 100, 1, 8000feb, 2, 200, 1, 7600feb, 3, 300, 1, 9200feb, 5, 500, 2, 5000feb, 4, 400, 1, 8300Is there a way through MDX to get a calculated measure that tells me the average number of hours flought during the month by captains?? For examplejan ((9000+8500)/2)/60 = 145.8feb ((8000+7600+9200+8300)/4)/60 = 137.9 The filter of captain is easy but how do I count how many distinct captains (there can be several registers per month per pilot) really had activity during the month?Thanks in advance |
|
count distinct