SharePoint24x7 It's all about SharePoint.

17Jul/140

Article – Configuring PerformancePoint Services (PPS) in SharePoint 2013

Posted by Joy

What is PerformancePoint Services (PPS)?

As per TechNet:

PerformancePoint Services in SharePoint Server 2013 is a performance management service that you can use to monitor and analyze your business. By providing flexible, easy-to-use tools for building dashboards, scorecards, and key performance indicators (KPIs), PerformancePoint Services can help individuals across an organization make informed business decisions that align with companywide objectives and strategy.

PerformancePoint Services lets you create rich dashboards, aggregating content from multiple sources and displaying it in a web browser in an understandable and collaborative environment. The rich interactivity of the dashboards lets you to analyze the latest information and work with the data quickly and easily to identify key opportunities and trends. PerformancePoint Services and its authoring tool Dashboard Designer let you display key performance indicators (KPIs) and data visualizations in the form of scorecards, analytic reports, and filters. You can integrate with SQL Server Reporting Services (SSRS)and Excel Services in addition to create scorecards that bring together data from multiple data sources to track and monitor key drivers of your business.

Configuring PerformancePoint Services is very easy if you have experience already configuring services such as Excel Services, Secure Store Services, PowerPivot, etc…

In this article I’m trying to help you with the various information which are required for configuring PerformancePoint Services service application.

Prerequisites for configuring PPS:

  • SharePoint Server 2013 Enterprise – before we get started with the configuration of PPS, we need to make sure that we have SharePoint Server 2013 Enterprise edition in order to use PPS. PPS is available only with the Enterprise edition of SharePoint Server.
  • ADOMD.NET – SharePoint 2013 Prerequisites Installer installs ADOMD.NET 9.0 automatically in to your environment. However, PPS requires ADOMD.NET 10 and ADOMD.NET 11 to be installed in your environment.
Task 1 – Verify what version of ADOMD.NET is installed in your environment
  • Navigate to C:\Program Files\Microsoft.NET\ADOMD.NET\
  • If you have ADOMD.NET 9, ADOMD.NET 10 and ADOMD.NET 11 installed, you will see something similar to the followingADOMD.NET install folder
  • If you don’t have either 100 or 110 folders, which means you don’t have either ADOMD.NET 10 or ADOMD.NET 11 installed in your environment. Depending on the version you need to install, you can use either of the following links to download and install ADOMD.NET:
Task 2 – Grant Application Pool Service Account access to SharePoint Content Database
  • Open SharePoint 2013 Management Shell. Make sure to Run as Administrator.
  • Grant application pool service account access to the content database using following cmdlets
    $webApp = Get-SPWebApplication
    http://intranet.team.com

    $webApp.GrantAccessToProcessIdentity(“TEAM\SP_Services”)

Task 3 – Create PerformancePoint Service Application instance
  • Open SharePoint 2013 Central Administration web site
  • Navigate to Manage service applications page from Application Management section
  • Select New from the Create group in the ribbon and select PerformancePoint Service ApplicationNew service application
  • Enter a Name, Database Server, Database Name and Application Pool details and click Create.Capture2
  • Click OK in the service application instance creation conformation page
Task 4 – Start PerformancePoint Services service
  • Open SharePoint 2013 Central Administration web site
  • Navigate to Manage services on server from System Settings section
  • Check the status of the Performance Point Service service. Start it if it’s not started already.
    Capture4
4Jun/140

Article – Fixing PowerPivot Management Dashboard Errors

Posted by Joy

We installed SQL Server PowerPivot for SharePoint and we also executed PowerPivot for SharePoint 2013 Configuration tool and configured PowerPivot for SharePoint.

Now we need to make sure that PowerPivot Service Application instance is configured correctly for us to move forward. Unlike any other service application settings/ configuration pages, PowerPivot Service Application instance settings page is considered as the Dashboard for PowerPivot Service Application instance.

Let’s go and explore PowerPivot Service Application instance and it’s configuration.

  • Open SharePoint 2013 Central Administration web site. Click Manage service applications from Application Management section.
  • Click PowerPivot Service Application instance name to navigate to PowerPivot Management Dashboard.PowerPivot Service Application instance
  • Most of the time, you will end up getting following screen. You will see Excel Services error in the Infrastructure – Server health web part and another error in Workbook Activity – Chart web part. The reason for this error is, App Pool Service Account doesn’t have access to Central Administration content database.PowerPivot Management Dashboard
  • Open SQL Server Management Studio and connect to Database Engine.
  • Expand Databases folder and locate the SharePoint Central Administration content database. Expand the Security folder and then expand the Users folder.Granting membership in SQL Server
  • Select the App Pool Service Account, right click the user account and select Properties. Select Membership page from the Select a page list. Select SPDataAccess database role membership.Granting membership in SQL Server
  • Click OK and close SQL Server Management Studio.

Now you can go and verify PowerPivot Management Dashboard to see that both Red X are gone.

7May/140

Article – Associating PowerPivot SQL Server Analysis Services server instance with Excel Services

Posted by Joy

In my previous article, I demonstrated how to install SQL Server PowerPivot for SharePoint. After installing PowerPivot for SharePoint, you need to configure it before start using it. One of the configurations is associating PowerPivot SQL Server Analysis Services server instance with the Excel Services.

This article guides you through the process of associating PowerPivot SQL Server Analysis Services server instance with Excel Services.

  • Open SharePoint 2013 Central Administration web site. Select the option Manage service applications from the Application Management section.Application Management
  • Click Excel Services service application name to navigate to Manage Excel Services Application page.Manage service applications
  • Select Data Model Settings option from the Manage Excel Services Application page to navigate to Excel Services Application data Model Settings page.Manage Excel Services
  • Click Add Server from Excel Services Application Data Model Settings page to associate PowerPivot SQL Server Analysis Services instance with Excel Services.Excel Services Data Model Settings
  • Enter the name of the server in the Server Name field including PowerPivot SQL Server Analysis Services instance name and click OK.Add Server
  • Now you can see PowerPivot SQL Server Analysis Services server is associated with Excel Services.
    Add Server

Now you can move on to other configuration steps Smile

2Apr/140

Article – Installing SQL Server PowerPivot for SharePoint 2013

Posted by Joy

Self-service BI was introduced with SQL Server 2008 R2 with the introduction of PowerPivot. PowerPivot for Excel and PowerPivot for SharePoint became very popular among business users and it have them the opportunity to work with large amount of data within Excel with the ability of slicing and dicing data for detailed analysis.

This article guides you through the process of installing PowerPivot for SharePoint.

PowerPivot is not part of SharePoint or Excel and it is part of SQL Server. You need to have SQL Server Enterprise or Business Intelligence edition to use PowerPivot with Excel and SharePoint. You can install PowerPivot in either a SharePoint Server, Existing SQL Server or separate/ dedicated server. If you install PowerPivot on a SharePoint server, to use PowerPivot for SharePoint, you don’t have to install PowerPivot for SharePoint Add-In. If you install on an existing SQL Server or a dedicated server, you need to install PowerPivot for SharePoint Add-In in all the SharePoint Servers to get full feature set.

  • Mount SQL Server installation media. I used SQL Server 2012 with Service Pack 1 for my installation.
  • Double click setup.exe and select Installation from left navigation options. Select New SQL Server stand-alone installation or add features to an existing installation option.SQL Server Installation Center
  • Installation will execute set of Setup Support Rules and click OK if you don’t see any errors.Setup Support Rules
  • Installation will check for any available product updates and include if any. Click Next to install any updates available.Product UpdateProduct Update
  • Installation will execute another set of Setup Support Rules and click Next if there are no errors.
    Setup Support Rules
  • Select the option Perform a new installation of SQL Server 2012 and click Next.
    Installation Type
  • Enter the Product Key and click Next.
  • Accept the License Terms and click Next.
  • Select the option SQL Server PowerPivot for SharePoint and click Next.Setup Role
  • Click Next from the Feature Selection page.Feature Selection
  • Installation will execute set of Installation Rules. Click Next if there are no errors.Installation Rules
  • Accepts the default values in the Instance Configuration page and click Next.Instance Configuration
  • Click Next from the Disk Space Requirements page.
  • Provide a Service Account for the SQL Server Analysis Services in the Server Configuration page and click Next.Server Configuration
  • Click Add Current User from the Analysis Services Configuration page to grant administrative rights to the current user for Analysis Services.
    Analysis Services Configuration
  • Click Next from the Error Reporting page.
  • Installation will execute set of Installation Configuration Rules. Click Next if there are no errors.Installation Configuration Rules
  • Click Install from the Ready to Install page to start the installation.
  • Installation will take few minutes and Complete page will appear when installation completes. Click Close from the Complete page.

Next, I will guide you through the next steps of configuring SQL Server PowerPivot for SharePoint.

29Mar/140

Article – Creating a BI Center and Testing Excel Services

Posted by Joy

Business Intelligence (BI) is one of the most compelling features in SharePoint. All the BI features of SharePoint come with the Enterprise edition of SharePoint. Following are some of the BI components come with SharePoint:

  • Excel Services
  • Visio Services
  • Access Services
  • Power View
  • PowerPivot
  • PerformancePoint Dashboard

In order to leverage all of these BI features in SharePoint, you need to create and configure a BI Center in SharePoint. In this article I will guide you through the process of creating a BI Center in SharePoint and testing Excel Services as Excel Services being a very important/ core feature for rest of the BI features in SharePoint.

Creating a BI Center

  • Navigate to SharePoint 2013 Central Administration web site
  • Select Create site collections link from Application Management sectionApplication Management section
  • From the Create Site Collection page, make sure you select the correct Web Application in which you want to create the BI Center. Provide a Title and an option Description. Provide a URL.Create Site Collection page
  • From the Select a template: section, go to Enterprise tab and select Business Intelligence Center site template. Provide a Primary Site Collection Administrator and click OK.Create Site Collection page
  • It will notify you saying that Site Collection has been successfully created. Open the new site and it will take you to the home page of the new BI Center.BI Center

Testing Excel Services

  • From the BI Center home page, from the Left Navigation (Quick Launch), select Site Contents link.BI Center
  • Select Documents libraryCapture7
  • Click the name of the Excel Services Sample Workbook to test the Excel Services.Capture8
  • You will see the following output if you have configured Excel Services correctly.Capture9

Now you are all set to explore rest of the BI features of SharePoint 2013. Smile