By powerpivotgeek (dwickert@hotmail.com), on August 2nd, 2010
In getting ready for a recent internal presentation on PowerPivot, I was asked what this button actually does . . . (see below)
The primary purpose for the settings page is to setup diagnostic tracing. The trace file itself is pretty straightforward, it is the regular SSAS tracing subsystem that we know and love . [...]
By powerpivotgeek (dwickert@hotmail.com), on June 17th, 2010
Attempting to use a modified version of the SharePoint v4.master page is a great way to style our SharePoint site. If you interested in doing this, then the first thing to do is to make sure that you go to the right place:
Go to Site Settings -> Site Collection Features -> Make sure “SharePoint Server [...]
By powerpivotgeek (dwickert@microsoft.com), on June 14th, 2010
While this is technically a pure SharePoint posting, we have found it useful in our labs. We have password resets all of the time and this cheat sheet was developed to make it as painless as possible. I hope you find it as useful as we do.
Step 1: Start Services.msc
For each service using the machine [...]
By powerpivotgeek (dwickert@microsoft.com), on May 21st, 2010
(Thanks to Ankur Goyal, one of the PowerPivot mid-tier testers, for this detailed write-up)
You might have noticed that Excel Services sometimes complains about how the PowerPivot workbook is organized. It reports an warning error like this one::
In this posting, I’ll talk about why these rectangles exist (i.e. what they do) and how you can have [...]
By powerpivotgeek (dwickert@microsoft.com), on May 18th, 2010
(Thanks to Ankur Goyal, one of the PowerPivot mid-tier testers)
SharePoint 2010 comes with a whole group of new developer tools. But there is none cooler than the Developer Dashboard. The Developer Dashboard allows you to monitor page load performance on SharePoint. Now how cool is that – you see how each element on the page [...]
By powerpivotgeek (dwickert@microsoft.com), on May 12th, 2010
Here is a cute trick for all of you ‘client’ jockeys out there. Sometimes you have a table that you, as a designer, have for some limited uses. Maybe the table exists for establishing relationships, or for intermediate calculations, but not for querying. How can you hide it? Well, it turns out that it is [...]
By powerpivotgeek (dwickert@microsoft.com), on May 12th, 2010
This will save you a few hours of debugging. Virtually every SharePoint feature and application, e.g. Excel, PPT, and Word Web Apps, do not support 64-bit browsers. In order to work around this behavior, please use a 32-bit browser. While others have issues around compatibility, this restriction applies to PowerPivot for one HUGE reason. And [...]
By powerpivotgeek (dwickert@hotmail.com), on April 27th, 2010
Recently we have been seeing some users complain about how the PowerPivot Excel client add-in deals with queries. There are three limitations that you need deal with when working with SQL (TSQL, PL/SQL, or whatever) and stored procedures:
The result set must have a name associated with each column. If you are not returning the column [...]
By powerpivotgeek (dwickert@microsoft.com), on April 14th, 2010
As more and more folks start to get into PowerPivot and SharePoint, there is a need to programmatically write entries into the ULS. Since all of PowerPivot and all of SharePoint share this common logging infrastructure, why not also include log entries from your own processes. Here is some sample code for doing that:
First via [...]
By powerpivotgeek (dwickert@microsoft.com), on April 7th, 2010
For all of you that are running a combined all-in-1 system, i.e. domain controller, SharePoint and all of PowerPivot (desktop + server), you will notice that if you are trying to debug with non-administrator accounts that you can no longer remote desktop on to your machine. This is because by default only administrators are allowed [...]
Recent Comments