SharePoint, PowerPivot, Power View and Multidimensional Analysis Services

This article was written to help me sort out SharePoint, PowerPivot, Power View and Analysis Services. Read on to discover the questions that arose as I embraced this technology set and the answers I’ve uncovered.

So what are the options for working with Power View within SharePoint with MDX as the source cube? Let me frame this a bit, I am referring to SharePoint 2013 and SQL Server 2012 SP 1 or SQL Server 2014. It appears that PowerPivot becomes the data source for Power View reports. That is, a PowerPivot workbook saved within a Document Library. So it seems feasible that building a PowerPivot report pulling from an MDX cube, then stored in a Doc Library should work. The first test is the Document Library, PowerPivot and MDX cube test. If this works the same way as using a tabular cube, then we are one step closer to a complete solution.

Continue reading “SharePoint, PowerPivot, Power View and Multidimensional Analysis Services”

SharePoint Adoption Kit – Show Me How Videos

Here is the collection of Show Me How videos from Microsoft for SharePoint 2010. These videos are part of the Microsoft SharePoint Adoption Kit and include some great examples. My favorites are video 1 – phonetic search, video 2 – co-authoring Word documents, video 6 – the Group Work Site and video 9 – workflow and document approval.

Sharepoint Adoption Kit Continue reading “SharePoint Adoption Kit – Show Me How Videos”

Microsoft Sharepoint User Profile Synchronization I – Clearing the Config Cache

While troubleshooting a failed User Profile Synchronization Service, I needed to clear the config cache. The config cache is where config settings are stored locally on the Microsoft SharePoint server, so a SQL call isn’t required. Sometimes these files get corrupted, which happened to me while setting up the User Profile Synchronization Service.

To clear them: Continue reading “Microsoft Sharepoint User Profile Synchronization I – Clearing the Config Cache”

Installing SharePoint 2010 SP1

As Jethro Tull used to sing, ‘Nothing is easy…’. Although installing SP1 for SharePoint 2010 isn’t hard, there are a few extra steps beyond running the .exe for SP1.

If installing SP1 for SharePoint Foundation 2010, then run:

  1. SP1 for SharePoint Foundation 2010
  2. SP1 for SharePoint Foundation 2010 Language Pack (if applicable)
  3. Cumulative Update from June 2011

If installing SP1 for SharePoint Server 2010, then run:

  1. Steps 1 and 2 from above
  2. SP1 for SharePoint Server 2010
  3. SP1 for SharePoint Server 2010 Language Pack (if applicable)
  4. Cumulative Update from June 2011

Finally, after installing SP1 and the Cumulative Update, you must run the SharePoint 2010 Products Configuration Wizard to tell the system it is now SP1.

SharePoint Designer Workflow – Majority Voting

Recently faced with the challenge of writing a SharePoint Designer workflow that moved a change request thru 6 steps. One of those steps asked 12 team members to vote on the request. As soon as a majority vote was determined, the step could end, and the workflow could continue. This meant not all 12 people needed to vote, the workflow only needed to know that more than 50% of the voters had chosen to approve or reject the request.

By leveraging the Task Customization Tools in SharePoint Designer 2010 and the Task Process Result Data source, here’s how I did it.

  1. Add Start Approval Process action to my workflow.
  2. Click Approval link to view the Approval Task page
  3. Change the name to ‘Majority Voting’
  4. Click on the Change the behavior of a single task link
  5. Scroll down to the When a Task Completes step
  6. At the end of this step add logic to end the Majority Voting task and continue on with the workflow
  7. In the screen shot below I’ve added the few lines required:
    1. Add comment to indicate changes
    2. Insert If any value equals value condition
      1. Click the first value link
        1.  Leverage the Task Process Results Data source for the first value of the condition. This Data source contains great fields for use in this situation.
        2. Select the Percentage of Approved Field from source.
        3. Click OK
        1. Change equals to is greater than
        2. Click the second value link and enter 50
      2. Add a Log to History List action
      3. Add a End Task Process action
      4. Add an Else-If Branch
      5. Add an If any value equals value condition
        1. Leverage the Task Process Result Data source again, this time using Percentage of Rejected field
        2. Change equals to is greater than
        3. Change second value to 50
      6. Add a Log to History List action
      7. Add a End Task Process action
  8. You have finished using the Task Customization Tools, in the breadcrumbs click on Editor to go back to the Editor for the main workflow
  9. Click on these users link
  10. Add the participants
  11. Swith from One at a time (serial) to All at once (parallel)
  12. Add a Title and Instructions
  13. Click OK
  14. The Majority Voting step is done

SP 2010: Create New Web Application and Site Collection

Create New Web Application

IIS Web Site

  1. Description: MOSS Web App – 80 (Consider TurtlePoint Web App – 80)
  2. Port: 80

Application Pool

  1. App Pool Name: MOSS Web App – 80 (Consider TurtlePoint Web App – 80)
  2. Account: spAppPool

Database Name and Authentication

  1. DB Name: MOSS_WebApp_Content

MOSS_WebApp_Content DB created
MOSS Web App Web – 80 Site created
MOSS Web App – 80 App Pool created

Create New Site Collection

Title and Description

  1. Title: Turtle Point

Template Selection

  1. Collaboration > Blank Site
  2. Activate these Site Collection Features
    1. SharePoint Server Enterprise Site Collection
    2. SharePoint Server Publishing Infrastructure
    3. SharePoint Server Standard Site Collection
    4. Publishing Approval Workflow if desired
  3. Activate these Site Features
    1. SharePoint Server Enterprise Site
    2. SharePoint Server Publishing
    3. SharePoint Server Standard Site
    4. Team Collaboration Lists

Primary Site Collection Administrator

  1. TURTLELLCAdministrator

No new database, web site or app pool created