Because PowerPivot for Excel and PowerPivot for SharePoint involve many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster contains all of the key components that make up PowerPivot in one view. This view includes nearly all of the logical architecture components and illustrates how these componets work together. Included in this diagram are the components for: PowerPivot for Excel PowerPivot for SharePoint Browser-Based Clients and their connection to PowerPivot Data Import and Data Providers in relation to PowerPivot Analysis Services Clients and their ability to connect to PowerPivot Timer Jobs, Health and Usage…
Month: April 2010
PowerPivot has RTM’ed…what’s next?
Woo hoo! It actually RTM’ed a couple days ago and I did tweet about it but neglected to also blog about it. As previously blogged, we have the Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment which I also chatted about in the SQL Server posting: How do I prepare for PowerPivot? What’s next? (atleast for the next couple of weeks) As noted in PowerPivotGeek’s posting PowerPivot has RTM’ed, he will be updating the install guides the the RTM version screenshots as well as we’ll be converting them into whitepapers downloadable from TechNet and sqlcat.com. We are completing a technical note of how…
Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment
What’s great about the newly published “Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment” is that it is a guide that has the end-to-end architecture design of PowerPivot for Excel and PowerPivot for SharePoint including hardware requirements, topologies, and deployment planning. If you want to know more about PowerPivot Planning and Deployment – this is the document. You can find the Microsoft SQL Server PowerPivot Planning and Deployment on SQLCAT and TechNet. Enjoy!
Dude, Where’s my PowerPivot workbook?
In homage to Rob Collie’s blog posting style (yes!…he has style, he has grace, …) and of course the movie “Dude, Where’s my Car?”, let’s ask a new question: Dude, where’s my PowerPivot workbook? And before you ask, we’re not talking about searching for the workbook somewhere in your “My Documents” folder, USB drive or SkyDrive. What we’re referring to here is the fact that you went ahead and saved your PowerPivot workbook to the SharePoint, typically through the Excel Save As or Save to SharePoint function as noted in the posting: Uploading #PowerPivot for Excel workbook using “Save As”…
Delegation, Claims, Active Directory…Oh My!…Aw Crap!
Heads up, this posting’s title was “User credentials could not be delegated and Active Directory” but I realized I needed a title that evoked my emotional state 😉 Do not fret or worry, this is not “yet another user credentials delegation” blog. After all, there are already the postings including Troubleshooting #PowerPivot Excel Services connectivity (written by yours truly) and Excel Services delegation (by PowerPivotTwins partner Dave Wickert). More importantly, if you want to debug and troubleshoot your way through the PowerPivot / Excel Services delegation issues, the coup-de-grace is Lee Graber’s excellent post: that The data connection uses…
Update SharePoint 2010 Farm Credentials Tips
Within your SharePoint environment – such as your PowerPivot for SharePoint single server install – a common task that you will need to do is to update the SharePoint Farm credentials when the password changes. You may be able to do this automatically by using the new SharePoint 2010 feature to plan automatic password change. But if you need to change your farm credentials, you can follow the instructions: How to change service accounts and service account passwords in SharePoint Server 2007 and in Windows SharePoint Services 3.0. But in the process of updating a PowerPivot for SharePoint single server…
Ramblings about missing time … and #PowerPivot sneak peek!
Wow, I just checked and its been more than a month since I did my last blog post! So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But I do have a good excuse! Really! Oh, and for those of you patient enough to read to the end, I do have an interesting sneak peek for you 🙂 RTM… aaaaaaahhhhhh!! RTM is driving me nuts…but then again, Dave Wickert (PowerPivotGeek) has been handling…
Denny Lee 