Calculate Times in Measures?

Question

Hello,

I have a question. Is it possible to display the measure over a percental ammount in time ? I have all the Start and End Times of each state in my database. So i want to display the state in relation to ther percentage of time ammount.

For Example i have 10 hours day:

Machine running: 5 hours
Machine not running: 3 hours
Machine in maintainance: 2 hours


so i get:
Machine running: 50%
Machine not running: 30%
Machine in maintainance: 20%

I hope my problem is understandable.

Thank you

Answer 1

If you have separate records for the start and end of each event you are going to probably have a hard time using SSAS over that format. 

With the example that you have given I think you will need to join the start and end into a single record, then you can easily calculate the duration within the one record. You will then have the duration for a given machine on a given day and can compare that to the available hours or even to the sum of all the hours for that machine on that day.

---

http://geekswithblogs.net/darrengosbell - please mark correct answers

Answer 2

I tried to explain my problem again in this threat. maybe you can help me.

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/9e636321-6e22-4ecf-aa58-d8600ecd95cf