Using PowerPivot to combine cube (SSAS) data with manual data
With the release of PowerPivot CPT3 you can connect to a SSAS cube, a feature i was really looking forward to and i think will be used a lot. The best mashup possible between traditional BI and ad hoc questions. Think about a salesof the current year compared to the forecast of this year. Where the Current year is available and the forecast is determined by an analyst in Excel.
First thing we notice when we open the PowerPivot window is the addition of Analysis services on the from database tab.
Tags: connection, excel