X++ Query for Grouping by Dimension

Recently, I was working on a requirement in our project for summarizing General Ledger Transactions grouped by Dimensions, For a little moment, I was stuck as Dimension field in the query needed to be handled in special way. Here is the query and we have to write Dimension with the array suffixed to it as shown here