We have Sage 200c On-premise. The schema comprises of a Cube, Warehouse and Finally Sage Database. 

How do I know how data is being surfaced? Example: How do I trace data from Opening Balance, Transaction Listings (movements) through to Closing balance? 

How do I find out which datasets/tables are in the Cube and which Datasets are in the Warehouse? 

Thanks in advance