Combine two sources (in our case ssas) using PowerPivot
User Rating: / 0
PoorBest 
Written by Kasper de Jonge   
Wednesday, 11 August 2010 00:05

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.

Read more...

 

  Tags: ssas, excel, load
 

Varigence Vivid