brucekoivu (10/17/2013)
You may need POWERPIVOT which is an SQL 2008 Enterprise feature.
I'm very curious what PowerPivot has to do with PerformancePoint.
You only "need" it if you're going to build a dashboard on top of PowerPivot data, but you can demo functionality with regular SSAS.
brucekoivu (10/17/2013)
There are a few other enterprise features that are useful for data cube performance too: pre-fetching and cube write back.
Cube write-back is hardly a performance feature. It allows you to update your cube from Excel.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP