Combine two sources (in our case ssas) using PowerPivot
As part of our PowerPivot for the regular Information worker today a blog post on how to use PowerPivot to combine information from two sources into a single information product.
In our case the information is stored inside two analysis services cubes that the BI department had made accessible to us.
We want to analyze the order amount per product, year, month and country we have in one cube with the actual order count we have in another cube.