There is a handy tool developed to browse the dataflow in BW system easily and effectively using BW system scout. It is offered by Bluetelligence.
Below is the link to get the trial version:
With his help you can easily maintain an overview of your SAP BW, SAP BO, SAP BPC, SAP HANA, ERP and SAC metadata, perform housekeeping tasks and can reliably carry on impact analysis of the changes.
Complex dataflows can be easily visualized including entire applications and data models.
Mapping of objects can be viewed using data lineage and cross system object comparison can be done.
This allows to understand the correlation of metadata – essential starting point for any analysis.
A transport request can be analyzed to see the dependencies. An ABAP code or SQL script scan can be done to search the code for specific statements. In this way, you can be sure that the change request do not have unwanted consequences.
You can also check whether the list of objects in a TR are in correct naming convention or not.
You can also perform a cross-system inventory of numerous object types and identify when certain objects were last called and loaded.
Below is the link for user manual for BW system scout which has all the feature listing of what it can do: