By Denny Lee, Ed Campbell Introducing RBS So what is RBS and why would I want to use it in order to help my PowerPivot for SharePoint farm? Well, RBS in this particular case is Remote Blob Store which was introduced as part of one of the SQL Server 2008 Feature Packs. As of this post, the current version can be found in the SQL Server 2008 R2 November CTP Feature Pack (search SQL Server 2008 R2 Remote Blob Store). Simply put, remote blob store allows you to put blobs outside of the SQL Server database so you can reduce…
Month: February 2010
PowerPivot for SharePoint Quick tip: Don’t forget to install Desktop Experience
For those of you who are using Windows 7 client, you should be good-to-go already because you already have Desktop Experience installed. But if you are using a Windows Server OS (e.g. Windows Server 2008, Windows Server 2008 R2), you will need to install it as part of an additional feature via the Server Manager. Why you ask? Typically when you upload files to SharePoint (including the PowerPivot Gallery), you will do save-as from Excel and/or use the SharePoint UI to upload the file to the URL http://$servername$/PowerPivot%20Gallery/. But if you want to automate the upload of files, you’ll have…
Granting Excel Services access rights to your #PowerPivot for SharePoint Farm
In many of test PowerPivot for SharePoint deployments, the SharePoint Farm Administrator is used for all services including Excel Services during installation or configuration. This is a great and easy way to get yourself up and running fast. But a best practice is to use a different managed account for the application pool that Excel Services (and PowerPivot Services for that matter) is running under. This way Excel Services (and other services using that application pool) do not have Farm Administrator rights. But in the process of doing this, one might have forgotten to grant Excel Services rights to the…
Pivots, Cube Formulas, Named Sets … Oh my!
Over the last few days, @PowerPivotPro has been calling me out for diving into the deep end into his world of Excel and getting the proverbial egg on my face (Joker picture not-withstanding). He’s called me out, challenged my geek hood, and sliced / diced my postings (pun intended). I was going to let this all slide…and then he started using “eh?!” in his postings!!!! So the gloves are coming off!!! … Or are they? CubeSet and CubeRankedMember cube formulas are great! For starters, in paying homage to someone who is vastly superior in Excel (I’m sure in other things…
Denny Lee 