WizzoP
asked on
SSAS Calculated Measure for % time spent
Hi Everyone,
I'm fairly new to SSAS and MDX, and I'm having trouble with a calculated measure in SSAS.
I am recording periods of driving time for a fleet of vehicles, and have measures which record when vehicles are moving and stopped.
I have dimensions for Date and Vehicle (which has a hierarchy to allow me to group vehicles by region, country etc)
Now, for a given date range and subset of vehicles, I can easily see the total time spent driving, but what I really want to do is calculate the % of time spent driving (i.e the utilisation of my vehicles).
As a trivial example, suppose I have just 2 vehicles, one of which drives for exactly 6 hours per day over a 5 day period, and the other drives for 18 hours per day over the same period. What I want is a calculation which returns 0.5 (50%) when I query my 2 vehicles for the 5 days period.
I'm fairly new to SSAS and MDX, and I'm having trouble with a calculated measure in SSAS.
I am recording periods of driving time for a fleet of vehicles, and have measures which record when vehicles are moving and stopped.
I have dimensions for Date and Vehicle (which has a hierarchy to allow me to group vehicles by region, country etc)
Now, for a given date range and subset of vehicles, I can easily see the total time spent driving, but what I really want to do is calculate the % of time spent driving (i.e the utilisation of my vehicles).
As a trivial example, suppose I have just 2 vehicles, one of which drives for exactly 6 hours per day over a 5 day period, and the other drives for 18 hours per day over the same period. What I want is a calculation which returns 0.5 (50%) when I query my 2 vehicles for the 5 days period.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.