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.