BIP Account query to get the rollup data in a a row

Summary:

BIP Account query to get the rollup data in a a row

Content (please ensure you mask any confidential information):

Account 1 has rolled up to child 8, child 8 rolled up to Child 7, Child 7 rolled up to Child 6.

Query needs to get in one row with Account1,Child8,child7,child6

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):