In BEx Analyzer you could jump into another query from a query / workbook. The GoTo-Function make sense if you have one query for overview and one for detail.
This function is also available in Analysis for Office. It must be maintained as before in transaction RSBBS. After that, the following entry appears in the Analysis for Office workbook.
These posts might also be intersting: