I'm trying to build an accumulated time hierarchy like the following:
per January = January
per February = January + February
per March = January + February + March
Is the any built in support in SQL Server to create such a hierarchy in a standard time dimension or does anyone know an other way to archive this?