| Using PowerPivot to combine cube (SSAS) data with manual data |
| Written by Kasper de Jonge |
| Monday, 23 November 2009 12:47 |
|
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.
|
Author articles
- Use PowerPivot DAX to automatically report on the last month that has data
- Using the excel function SEARCH in PowerPivot DAX
- Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible
- What is that PowerPivot pivottable context they keep talking about?
- Use Time intelligence functions to do a running sum of the last 6 months with PowerPivot
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
- Recorded webcast - A Preview to PowerPivot Server Best Practices
