|
||||||
|
Who is this mystery man?
Click on the icon to find out.  |
So you think that you have done everything right, but still SQL setup (in PowerPivot SharePoint integration mode) still reports “You don’t have a ‘Complete’ SharePoint installation.” How can this happen? You might not have followed the installation guide. It tells you to first select “Farm” and then “Complete” on your first two screens after you [...] One of the special considerations that arise when demonstrating PowerPivot is that you would like to ensure the workbooks that you are showing are kept in memory all of the time. PowerPivot does not have a built-in ‘pin’ feature to do this, but there is nice trick that you can use. Here is what I [...] A trick for the client-side folks doing build-to-build reinstallations (or if you wish to clear all of the PowerPivot code from your client): besides uninstalling “Microsoft PowerPivot for Excel” (via control panel Add/Remove/Uninstall Programs, the exact wording varies depending on the OS you are running), you may also have to delete files in: C:\Program Files\Microsoft Analysis [...] This is one of the two main errors that users could see from Excel Services when using PowerPivot. This is encountered when refreshing PowerPivot data connections or performing an action which requires re-querying the PowerPivot database, such as clicking on a slicer or expanding a node in a pivot table. To debug, some level of [...] A number of people have had issues with PowerPivot installation failures in CTP3. Hopefully, we have resolved all of these for RTM, but I can tell you that setup is still a bit tricky. To give you something of an understanding, the “New Farm” installation option is responsible for getting your machine up and running [...] A number of people have hit this issue and so it deserves a quick walkthrough of why it (unfortunately) can happen and how you fix it. The error occurs when you try to select a Document Library of type PowerPivot Gallery (sometimes referred to as Report Gallery). After installing Power Pivot for SharePoint, all new [...] We have gotten lots of feedback about the new CTP3 PowerPivot Management Dashboard feature. Most folks are excited about the new reports and can see how the reports give you an unparalleled ability to ‘peek’ inside the running services. However the default “wait-a-day” update cycle can see a bit long. A day-long cycle period seems [...] Hopefully this will be my first of many posts as I have been meaning to try and start doing memory dumps to this blog. Hopefully some of those memory dumps also made it into our docs … I tried. So most people who are used to using Windows based services are used to using Service Control [...] 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 [...] Denny Lee and I are doing an Academy Live webcast next week on our early PowerPivot best practices. Please feel free to join us! Registration is at: https://swrt.worktankseattle.com/webcast/3475/preview.aspx SQL90CALT: A Preview to PowerPivot Server Best Practices Date: December 15, 2009 Abstract: |
|||||
|
Copyright © 2010 PowerPivotGeek, Dave Wickert - All Rights Reserved |
||||||
Recent Comments