Hi all, I resolved it by subtracting current month from year to date which gave me required results. Thank you.

Hi @Gianni Ceresa , Thank you for quick response. I had previously worked on OWB which is also an ETL tool and it provides Derive capability which in turn creates three layers even dimension hierarchy drill downs. I was just wondering if there is any integration in informatica or erwin data modelling. Since if data…