A long time ago, but not in a galaxy too far away…actually, just in Redmond, WA,… there was A NEW HOPE for easier PowerPivot for SharePoint installations! So hats off to the Analysis Services product team for building an easier PowerPivot for SharePoint installation by providing us with the “New Server” installation choice. Yet, even with the easier installation steps, it is important to make sure you do the steps in the right order and have the correct prerequisites installed to make it a smooth installation experience. During the CTP (Community Technology Preview) process, a number of us had got…
Month: August 2010
Analysis Services ROLAP for SQL Server Data Warehouses
You’re sh*&ting me. No way. Man, that sucks. rocks! – Toby Lee Shavers, from XXX (2002), altered of course! And before you start, yes, I’m starting to follow the schtick of quotes from fellow PowerPivot bloggers Rob Collie (@PowerPivotPro) and Kasper de Jonge (@Kjonge). For more memorable movie quotes, check out http://www.powerpivotpro.com/ . After about 14 months of testing, validation, analysis, and all sorts of hardware headaches and dancing, I am proud to say that I have finally published the Analysis Services ROLAP for SQL Server Data Warehouses whitepaper with my trusted partners-in-crime Thomas Kejser and Kay Unkroth. Thomas for…
Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!
One of the cool things with PowerPivot is to click on an SharePoint List’s Export as Data Feed (i.e. an Atom feed) and its data can be imported directly into a PowerPivot for Excel workbook. To get this thing to work, one of the key things that I remind people regularly is to make sure you install ADO.NET Data Services Update for .NET Framework 3.5 SP1. ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows 2000, Windows Server 2003, Windows XP, Windows Vista and Windows Server 2008 ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows…
PowerPivot Technical Diagram: PowerPivot Security Architecture
Just in case you didn’t already know, we just uploaded the PowerPivot Security Architecture technical diagram on to sqlcat.com / MSDN. To get access to the PDF, XPS, and/or VSD files, please click through to: http://sqlcat.com/whitepapers/archive/2010/08/17/powerpivot-technical-diagram-powerpivot-security-architecture.aspx Enjoy!
Denny Lee 