Analysis Services Time Measures

  • 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


    All the best,

    Duncan

  • I would calculate your measure at the lowest level.  In your case hours.  Then do a simple calculation to convert to days:hours.

  • 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