I have 2 SSAS cubes. I need to create a single pivot table that shows data from both of these cubes. (i.e. there is a cost cube and a revenue cube, I need to have a pivot table to compare the cost to revenue.) I'm unsure of how to do this in Excel. Can this be done with an MDX query? If so, how do I go about setting this up?