Last week we looked at PowerPivot for analyzing Dynamics GP data. This week someone asked if you can connect to multiple cubes with PowerPivot. Yes you can. For testing I connected to the GP Financial Cube and Sales Cube and then was able to join them in PowerPivot. These cubes were both on the same server but given the way that PowerPivot connects that there is no reason that you couldn’t join cubes across servers assuming that the you have the right access.
Weekly Dynamic: PowerPivot and Multiple Cubes
Tips & Hidden FeaturesReporting & BIExcel & Office
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.