To use with Sage 300: Go to Properties > Cubes > SQL Query and replace 'SAMLTD' with your Company 1 database ID and 'ORCLTD' with your Company 2 database ID. There are 4 parts to the queries, linked by UNION ALL
Note: The cube now includes the Opening balance from GLAFS. You can't add multiple years on the Consolidated balance sheet view.
This cube requires Info Explorer Full or Writeback licence.