US10628451B2 - System and Method for Supporting Queries Having Sub-Select Constructs in a Multidimensional Database Environment