I noticed from the query log that there is an explicit condition which limits the hierarchy version based on current date which if removed can rectify this issue

This is a key feature required for end user adoption. Many leading self service reporting tools have this option