July 24, 2007 at 2:15 am
Hi, within a cube I wish to hold a measure which is based on the time it takes to complete a process.
These process's take hours and are very likely to take days. Consequently the measure must be in days and hours (1 day, 4 hours, 8 hours, 3 days 10 hours etc.). The measure should be capable of being used in the MDX average function as the average time for these processes in the key indicator I am trying to derive. I can show this in decimals (1.25 days, 3.00 days, etc.), but it is more relevant to users in the days:hours format.
In the back-end SQL 2000 database, the fact table holds a start and end date for each process as a smalldatetime.
Any ideas please?
Thanks
Duncan
July 24, 2007 at 9:43 am
I would calculate your measure at the lowest level. In your case hours. Then do a simple calculation to convert to days:hours.
July 24, 2007 at 9:43 am
Sorry... should have specified that the calulation would be a calculated member in the cube. Otherwise the Days:Hours will not rollup properly.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply