Thanks Gianni. You don't need aggregate tables in the RPD, you just need to model some aliases using a BETWEEN instead of a = to calculate your YTD figures.-----your statement from above I already joined fact to month table ,fact to qtr table ,fact to year table using there respective keys . in logical layer I am creating…

Thanks for your reply . In our system we don't have aggregate tables and based on effective date in the fact table we have created monthkey , qtrkey, yearkey and joined to their respective time dimension tables . but I expected 12c to be same as 11g in terms of query building for time series calculations.

let me know if anyone got a chance to look at my issue above .