I need some advise from you guys....
I have a scenario as follow:
I want to measure a time taken to finish one process. A process consist of several steps and a step consist of several tasks.
I want to see how long does it take from one task to another task, as well as step to another step.
I want to be able to see what's the opening balance (in minutes), WIP balance (in minutes) and closing balance (in minutes) of each level.
I have a calculated measure to calculate opening balance, WIP balance and closing balance at any point in time.
I also have the following condition for calculating opening balance:
If the date (can be any date) is not the first sibling of any date level (first day of the month, first month of the quarter, first quarter of half year, first half year of the year) then use previous member balance
else use the balance of first sibling.
If today is 5 September 2010, then I should use balance of 4 September (day level), which is a calculated measure itself
If today is 1 September 2010, then I should use balance from September (month level), again this is the calculated measure itself.
I am nearly sure if I had taken the wrong because the performance is really bad, especially when I drill down into Day level.
View Complete Post