How to show time Hierarchy in Query report / RSRT Transaction based on CDS View?

Hello Experts,

I want to show a time hierarchy( Year > Month > Date) in RSRT / Query Report<query browser> as shown in the below snapshot. are there any standard CDS views available to get this hierarchy? or else

Could you please help me anybody, How to achieve that?

Thanks In Advance,

Bhargava