Query on Parent segment value

Summary:

While using Ledger Agent, if I am writing a query at Account child level, I am getting the output. The same query does not provide any result if an Account parent is selected.

Content (please ensure you mask any confidential information):

The following query is working

"Show balance of account Cash Book Suspense for Entity **** in 12-26".

The following query does not work and I get an Error message

"Show balance of account Total Cash at Bank for Entity **** in 12-26." (Please note this account is a parent to previous Account. The balance cube has value at parent level.