We have a accumulating fact table with the different calculated measures showing the time duration between different phases. All the different phases should appear as different categories of a dimension.
This could have been simpler if the grain of fact table was at a phase level. BUt in these case calculating the durations between stage 1 to stage 2...n becomes a nightmare.
Thanks in advance for your help
This could have been simpler if the grain of fact table was at a phase level. BUt in these case calculating the durations between stage 1 to stage 2...n becomes a nightmare.
Thanks in advance for your help