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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy