Fresh SharePoint 2013: Performance Point Error: System.IO.FileNotFoundException: 'Microsoft.AnalysisServices.AdomdClient,

If you've recently created a SharePoint 2013 Virtual machine that's an all in one image, you may have looked through your log files to find a critical error with Performance Point. The error looks like this:

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

This has to do with Central Administration being loaded on the Web Front End as explained by Microsoft:

If you install PowerPivot for SharePoint into a farm that has this topology (Central Administration, without Excel Services or PowerPivot for SharePoint), you must download and install the Microsoft ADOMD.NET client library if you want full access to the built-in reports in the PowerPivot management dashboard. Some reports in the dashboard use ADOMD.NET to access internal data that provides reporting data on PowerPivot query processing and server health in the farm.
Reference: http://msdn.microsoft.com/en-us/library/ee637433.aspx

To fix the issue, simply go to the SQL Server 2012 Feature Pack Page (assuming you're running 2012) and download/install the Microsoft® SQL Server® 2012 ADOMD.NET package

SharePoint 2013 permission levels vs SharePoint 2010 permission levels

If you're wondering what's changed in SharePoint 2013 permissions, don't hold your breathe.  Not much.  Well, not much on the surface at least.  There's a whole new set of security event handlers tied into user and group management, but in terms of security permissions in a browser, there's little difference between SharePoint 2013 and 2010.

I wanted to provide a breakdown of all the SharePoint 2013 Permission Levels and compare them to 2010 to see if anything has changed.  Only one real change:  Override Check Out is now Override List Behaviors.

SP2010	Override Check Out	Discard or check in a document which is checked out to another user.
SP2013	Override List Behaviors	Discard or check in a document which is checked out to another user, and change or override settings which allow users to read/edit only their own items

For a full list of each version side by side:

SharePoint 2013	SharePoint 2010
List Permissions	List Permissions
Manage Lists	Manage Lists
Override List Behaviors	Override Check Out
Add Items	Add Items
Edit Items	Edit Items
Delete Items	Delete Items
View Items	View Items
Approve Items	Approve Items
Open Items	Open Items
View Versions	View Versions
Delete Versions	Delete Versions
Create Alerts	Create Alerts
View Application Pages	View Application Pages
Site Permissions	Site Permissions
Manage Permissions	Manage Permissions
View Web Analytics Data	View Web Analytics Data
Create Subsites	Create Subsites
Manage Web Site	Manage Web Site
Add and Customize Pages	Add and Customize Pages
Apply Themes and Borders	Apply Themes and Borders
Apply Style Sheets	Apply Style Sheets
Browse Directories	Browse Directories
Use Self-Service Site Creation	Use Self-Service Site Creatio
View Pages	View Pages
Enumerate Permissions	Enumerate Permissions
Browse User Information	Browse User Information
Manage Alerts	Manage Alerts
Use Remote Interfaces	Use Remote Interfaces
Use Client Integration Features	Use Client Integration Features
Open	Open
Edit Personal User Information	Edit Personal User Information
Personal Permissions	Personal Permissions
Manage Personal Views	Manage Personal Views
Add/Remove Personal Web Parts	Add/Remove Personal Web Parts
Update Personal Web Parts	Update Personal Web Parts

SharePoint 2013 Permissions

SharePoint 2013 Beta is out and I thought I'd look through the permissions and provide a list of the full list of permissions.  I'll post another blog shortly on a comparison to see what the differences are:

List Permissions
	Manage Lists - Create and delete lists, add or remove columns in a list, and add or remove public views of a list.
	Override List Behaviors - Discard or check in a document which is checked out to another user, and change or override settings which allow users to read/edit only their own items
	Add Items - Add items to lists and add documents to document libraries.
	Edit Items - Edit items in lists, edit documents in document libraries, and customize Web Part Pages in document libraries.
	Delete Items - Delete items from a list and documents from a document library.
	View Items - View items in lists and documents in document libraries.
	Approve Items - Approve a minor version of a list item or document.
	Open Items - View the source of documents with server-side file handlers.
	View Versions - View past versions of a list item or document.
	Delete Versions - Delete past versions of a list item or document.
	Create Alerts - Create alerts.
	View Application Pages - View forms, views, and application pages. Enumerate lists.
Site Permissions
	Manage Permissions - Create and change permission levels on the Web site and assign permissions to users and groups.
	View Web Analytics Data - View reports on Web site usage.
	Create Subsites - Create subsites such as team sites, Meeting Workspace sites, and Document Workspace sites.
	Manage Web Site - Grants the ability to perform all administration tasks for the Web site as well as manage content.
	Add and Customize Pages - Add, change, or delete HTML pages or Web Part Pages, and edit the Web site using a Microsoft SharePoint Foundation-compatible editor.
	Apply Themes and Borders - Apply a theme or borders to the entire Web site.
	Apply Style Sheets - Apply a style sheet (.CSS file) to the Web site.
	Create Groups - Create a group of users that can be used anywhere within the site collection.
	Browse Directories - Enumerate files and folders in a Web site using SharePoint Designer and Web DAV interfaces.
	Use Self-Service Site Creation - Create a Web site using Self-Service Site Creation.
	View Pages - View pages in a Web site.
	Enumerate Permissions - Enumerate permissions on the Web site, list, folder, document, or list item.
	Browse User Information - View information about users of the Web site.
	Manage Alerts - Manage alerts for all users of the Web site.
	Use Remote Interfaces - Use SOAP, Web DAV, the Client Object Model or SharePoint Designer interfaces to access the Web site.
	Use Client Integration Features - Use features which launch client applications. Without this permission, users will have to work on documents locally and upload their changes.
	Open - Allows users to open a Web site, list, or folder in order to access items inside that container.
	Edit Personal User Information - Allows a user to change his or her own user information, such as adding a picture.
Personal Permissions
	Manage Personal Views - Create, change, and delete personal views of lists.
	Add/Remove Personal Web Parts - Add or remove personal Web Parts on a Web Part Page.
	Update Personal Web Parts - Update Web Parts to display personalized information.

SharePoint 2013 and I are "working on it..."

Just installed SharePoint 2013 and like most beta products some of the performance optimizations still haven't been applied yet, so expect for some delays in the actions you take.  I'll be working on posting up some blogs in the upcoming weeks for things you can do with 2013.  So in the mean time, I'll be:

Adding Top Link bar to SharePoint Basic Search Center Template

The Basic Search Center template in SP Foundation 2010 uses the minimal.master master page rather than the v4.master.  The search center template actually requires some additional content placeholders that the v4.master does not support.  I recently needed to add the Top link navigation to this template and decided to add the lines to the minimal.master to achieve this functionality.  Editing the master page allowed the change to persist to the results.aspx page as well which was the desired functionality.  To make the change, open the minimal.master page using SP Designer 2010 and find the following lines:

 <h3 class="s4-mini-header">
    <asp:ContentPlaceHolder id="PlaceHolderPageSubTitle" runat="server" />
   </h3>
  </div>
 </div>

The last line should be around line 118.  After the closing div tag add the following (Do not replace, just add):

<div id="s4-topheader2" class="s4-pr s4-notdlg">
     <a name="startNavigation"></a>
     <div class="s4-rp s4-app">
     </div>
     <div class="s4-lp s4-toplinks">
      <asp:ContentPlaceHolder id="PlaceHolderTopNavBar" runat="server">
        <asp:ContentPlaceHolder id="PlaceHolderHorizontalNav" runat="server">
 <SharePoint:AspMenu
   ID="TopNavigationMenuV4"
   Runat="server"
   EnableViewState="false"
   DataSourceID="topSiteMap"
   AccessKey="<%$Resources:wss,navigation_accesskey%>"
   UseSimpleRendering="true"
   UseSeparateCss="false"
   Orientation="Horizontal"
   StaticDisplayLevels="2"
   MaximumDynamicDisplayLevels="1"
   SkipLinkText=""
   CssClass="s4-tn"/>
 <SharePoint:DelegateControl runat="server" ControlId="TopNavigationDataSource" Id="topNavigationDelegate">
  <Template_Controls>
   <asp:SiteMapDataSource
     ShowStartingNode="False"
     SiteMapProvider="SPNavigationProvider"
     id="topSiteMap"
     runat="server"
     StartingNodeUrl="sid:1002"/>
  </Template_Controls>
 </SharePoint:DelegateControl>
        </asp:ContentPlaceHolder>
      </asp:ContentPlaceHolder>
     </div>
    </div>

Customizing SharePoint 2010 Tree View Navigation

In Site Settings->Tree View, you can check "Enable Tree View" and you have this nice control that gives you all sorts of drill down links to sites and content within them.  Here is an example of three projects that I have listed under my Projects site and what the default view is:

But what if you want to customize what is displayed and what isn't. In order to modify this, you have to change the master page and find the SPHierarchyDataSourceControl node.  There are some options that you can choose from documented here: http://msdn.microsoft.com/en-us/library/ms439089.aspx


   IncludeDiscussionFolders="false" 
   ShowDocLibChildren="false"
   ShowFolderChildren="false"
   ShowListChildren="false"

You can even change the title of what is displayed here.  I chose to change the title to Current Projects.

Since the SPHierarchyDataSourceControl also has a "RootWebId" member that can be changed, I can move all archived projects to a new location and create another tree control that pulls from that root.  This will give me the ability to display Current and Archived Projects to users. 

Overriding List Access Item-level Permissions

In SharePoint 2010, all lists have advanced settings where you can edit some of the Item-level Permissions. These item-level permissions give you the ability to override the default permissions users have to the list which can be beneficial if you want alter permissions to a specific list without needing to create new roles or moving around users. The figure below shows what options are available.

Since this overrides the default permission levels, the question was raised "what permission was required to override these settings?"

Let's start off by looking at the predefined roles that are provided OOTB. These roles each have a custom set of permissions associated with them. The image below displays these roles and I have highlighted with a red box the roles that will override the permissions set to the List Access of the SharePoint List. In OOTB terms, anything with a higher permission than “Approve” would override the list settings we are referring to starting at “Manage Hierarchy”.

The table below shows the Manage Hierarchy Role permissions on the left column and the “Approve” role on the right column. The permission level that grants the user ability to override the setting is highlighted in yellow inside the document.

Manage Hierarchy

Approve

Select the permissions to include in this permission level. Select All List Permissions Manage Lists - Create and delete lists, add or remove columns in a list, and add or remove public views of a list. Override Check Out - Discard or check in a document which is checked out to another user. Add Items - Add items to lists and add documents to document libraries. Edit Items - Edit items in lists, edit documents in document libraries, and customize Web Part Pages in document libraries. Delete Items - Delete items from a list and documents from a document library. View Items - View items in lists and documents in document libraries. Approve Items - Approve a minor version of a list item or document. Open Items - View the source of documents with server-side file handlers. View Versions - View past versions of a list item or document. Delete Versions - Delete past versions of a list item or document. Create Alerts - Create alerts. View Application Pages - View forms, views, and application pages. Enumerate lists. Site Permissions Manage Permissions - Create and change permission levels on the Web site and assign permissions to users and groups. View Web Analytics Data - View reports on Web site usage. Create Subsites - Create subsites such as team sites, Meeting Workspace sites, and Document Workspace sites. Manage Web Site - Grants the ability to perform all administration tasks for the Web site as well as manage content. Add and Customize Pages - Add, change, or delete HTML pages or Web Part Pages, and edit the Web site using a Microsoft SharePoint Foundation-compatible editor. Apply Themes and Borders - Apply a theme or borders to the entire Web site. Apply Style Sheets - Apply a style sheet (.CSS file) to the Web site. Create Groups - Create a group of users that can be used anywhere within the site collection. Browse Directories - Enumerate files and folders in a Web site using SharePoint Designer and Web DAV interfaces. View Pages - View pages in a Web site. Enumerate Permissions - Enumerate permissions on the Web site, list, folder, document, or list item. Browse User Information - View information about users of the Web site. Manage Alerts - Manage alerts for all users of the Web site. Use Remote Interfaces - Use SOAP, Web DAV, the Client Object Model or SharePoint Designer interfaces to access the Web site. Use Client Integration Features - Use features which launch client applications. Without this permission, users will have to work on documents locally and upload their changes. Open - Allows users to open a Web site, list, or folder in order to access items inside that container. Edit Personal User Information - Allows a user to change his or her own user information, such as adding a picture. Personal Permissions Manage Personal Views - Create, change, and delete personal views of lists. Add/Remove Personal Web Parts - Add or remove personal Web Parts on a Web Part Page. Update Personal Web Parts - Update Web Parts to display personalized information.

Select the permissions to include in this permission level. Select All List Permissions Manage Lists - Create and delete lists, add or remove columns in a list, and add or remove public views of a list. Override Check Out - Discard or check in a document which is checked out to another user. Add Items - Add items to lists and add documents to document libraries. Edit Items - Edit items in lists, edit documents in document libraries, and customize Web Part Pages in document libraries. Delete Items - Delete items from a list and documents from a document library. View Items - View items in lists and documents in document libraries. Approve Items - Approve a minor version of a list item or document. Open Items - View the source of documents with server-side file handlers. View Versions - View past versions of a list item or document. Delete Versions - Delete past versions of a list item or document. Create Alerts - Create alerts. View Application Pages - View forms, views, and application pages. Enumerate lists. Site Permissions Manage Permissions - Create and change permission levels on the Web site and assign permissions to users and groups. View Web Analytics Data - View reports on Web site usage. Create Subsites - Create subsites such as team sites, Meeting Workspace sites, and Document Workspace sites. Manage Web Site - Grants the ability to perform all administration tasks for the Web site as well as manage content. Add and Customize Pages - Add, change, or delete HTML pages or Web Part Pages, and edit the Web site using a Microsoft SharePoint Foundation-compatible editor. Apply Themes and Borders - Apply a theme or borders to the entire Web site. Apply Style Sheets - Apply a style sheet (.CSS file) to the Web site. Create Groups - Create a group of users that can be used anywhere within the site collection. Browse Directories - Enumerate files and folders in a Web site using SharePoint Designer and Web DAV interfaces. View Pages - View pages in a Web site. Enumerate Permissions - Enumerate permissions on the Web site, list, folder, document, or list item. Browse User Information - View information about users of the Web site. Manage Alerts - Manage alerts for all users of the Web site. Use Remote Interfaces - Use SOAP, Web DAV, the Client Object Model or SharePoint Designer interfaces to access the Web site. Use Client Integration Features - Use features which launch client applications. Without this permission, users will have to work on documents locally and upload their changes. Open - Allows users to open a Web site, list, or folder in order to access items inside that container. Edit Personal User Information - Allows a user to change his or her own user information, such as adding a picture. Personal Permissions Manage Personal Views - Create, change, and delete personal views of lists. Add/Remove Personal Web Parts - Add or remove personal Web Parts on a Web Part Page. Update Personal Web Parts - Update Web Parts to display personalized information.