PerformancePoint - Ultimate BI Reporting Tool for SharePoint

-
PerformancePoint is a Business Intelligence reporting feature of SharePoint. To start working with PerformancePoint, we have to configure it correctly and make sure that all the required services are started and correctly configured. Let us see which services are needed for PerformancePoint.

Services: 

1.       PerformancePoint Service
2.       Secure Store Service

To View and Enable the services, we have to go to SharePoint Administration->Application management->Service Applications (Manage services on server)



Now, let me guide you through the configuration process of the above mentioned services.
To do that, we have to go to Application management->Service Applications (Manage service applications)


Then, find out is the service applications are created or not. If not created then create the service applications by selecting "PerformancePoint Service Application" or "Secure Store Service" from "New" Toolbar. If these are already been created then click on the service applications to configure.


1.       Creating Secure Store Service Application: To Create a New "Secure store Service", we have to type a name for the application followed by entering the "Database Server"/"Database Name"/Authentication. This is basically the SharePoint Database Server with a new database name. Select "Windows Authentication" and create a new application pool with "Configurable" service account. Then provide this account access to the newly created database.

 
 
 2.       Configuring Secure Store service: To configure Secure Store Service, we need to generate a Key for "Unattended Account". So, we will click on "Generate New key" button from the toolbar.

 

 It will ask for "Pass Phrase" and "Confirm Pass Phrase" to Re-encrypt the Database. After that you will see that you will need to create a "Secure Store target Application" in this newly created "Store Service Application".

  3.       Creating PerformancePoint Service Application: To Create a New "PerformancePoint Service Application", we have to type a name for the application followed by entering the "Database Server"/"Database Name"/Authentication. This is basically the SharePoint Database Server with a new database name. Select "Windows Authentication" and create a new application pool with "Configurable" service account. Then provide this account access to the newly created database.

 
 

  4.       Configure PerformancePoint Service Application: Once the service application is created, we have to create an unattended service account so that we can use that account to access an external data source. Let us click on "Manage" button from toolbar.

 
 Then select "PerformancePoint Service Application Settings"

 
 And, select the "Unattended Service Account"->User name and Password. And, set other configuration variable as required otherwise keep them as is.

 

5.       After the service applications are created or configured, we have to make sure that the services and service applications are in "Started" state.
6.       Once the service applications are configured, it can be consumed to create PerformancePoint Reports, Dashboards, KPI Reports or even Scorecards.
7.       Turn On "PerformancePoint Services Site Collection Feature" in "Site Collection Administration" (Site Settings->Site collection Administration->Site Collection Features).
8.       Turn On "PerformancePoint Services Site Features" in "Site Settings" (Site Settings->Site Actions->Manage Site Features).
9.       After activating required features, we can consume the PerformancePoint service. We have to create a "Data Connections Library" (let us call it as PPS Connection) for reports and a "Performance Point Content List" (let us call it as PPS Configuration)
10.   To start working with PerformancePoint Designer click on "Add New Item" in "PPS Configuration" list. It will connect to the designer and open it up like this:

 
 Then right click on the PPS Connection to create the database connection from the database. If we are creating the report based on data cube, we can select the SQL Analysis Cube right from this screen.

 
 After creating the database connection, create the PerformancePoint report by right clicking on "PPS Configuration" and selecting appropriate type:

 
 After that we should be able to see the report to host inside SharePoint as an excellent BI reporting platform which has drill down and decomposition tree as well.

 
 

Comments

Post a Comment

Popular posts from this blog

How to Create SSRS Report on SharePoint List

-
Image
There is fairly an easy way to create a SSRS report on SharePoint List. By using an XML data source, we will get access to the SharePoint List. Then, create your own CAML query to manipulate SharePoint List Data. Here is the step by step example of creating SQL Reporting Services report on SharePoint List.   1. Create a Report Server Project in Visual Studio   2. Add a Data Source with following info types:   - Name : Should be the Data Source Name   - Type : XML   - Connection String : Should be the SharePoint Web Service for SharePoint List     [Example: http://myintranet/ts/FazlulsWorld/_vti_bin/lists.asmx ]   - Credentials: Windows Authentication or choose appropriate radio button   3. Add a New Report:   - Select Shared Data Source that you just created   - Paste the CAML Query into the Query String. You may have to find out the GUID for the SharePoint List and View on which you are re...
Read more

Database Testing With DBUnit

-
Image
DBUnit is an Open Source Database Testing Framework which was created by Manuel Laflamme. DBUnit is a Database Unit Testing Framework to Test Database Driven Classes, Procedures or Functions. NUnit, MVC .NET/Visual Studio testing platforms can be used to build a standard unit test suite. Developer should create a dataset, defined within an XML file, and then extends one of a number of parent classes to inherit pre-defined functionality in order to use the framework. An IDbConnection implementation to connect to the database, then DbUnit.NET can be used to test the data access code. Following Operations can be performed using DBUnit: UPDATE TRUNCATE INSERT REFRESH DELETE CLEAN_INSERT DELETE_ALL NONE Other Operations: Composite Operation Transaction Operation Identity Insert Operation DBUnit Support Databases: OracleDatabase MsSQL MySQL IbmDB2 IbmInformix H2 HypersonicSQL PostgreSQL SybaseSQL InterBase OpenBase8 SapDB/MaxDB Derby FrontBase HOW TO WRITE A DBUnit TEST CASE ? To create a ...
Read more

SAP RFC Integration through BizTalk

-
Image
It has been a long while since I published some technical write-ups into my blog. Today, I will try to elaborate on Integration mechanism with SAP though BizTalk middleware. As you are aware, SAP is a self-contained and modular system. So, communicating with SAP is a complex process. You have to have basic understanding of SAP Modules and Data Query/Retrieval process. But, communicating to SAP through RFC function calls has made it even easier. You can communicate with SAP RFCs in three different ways: 1.     Access SAP RFCs using WCF-SAP Adapter and SAP system credentials 2.     Access SAF RFCs through exposed RFCs as ABAP web services 3.     Access SAF RFCs through SAP Process Orchestrator, which is basically the SAP integration middleware Today, I will concentrate on No. 2, which is to communicate with SAP through RFC Web Services via ABAP web services. To do that, you need to expose SAP RFCs as consumable web services. Please follow THIS to expose RFCs as ...
Read more