Microsoft Office Tutorials and References
In Depth Information
Other application-level services commonly employed as part of a PerformancePoint solution include the
Secure Store Service (SSS) and SQL Server Reporting Services (SSRS). SSS provides a location for logon credentials
to be securely stored within the SharePoint environment. For more details on the purpose and configuration of the
Secure Store Service, see Chapter 5. Although it is not part of SharePoint Server, the SSRS component of SQL Server
is frequently leveraged in conjunction with PerformancePoint solutions due to the ease with which it allows complex
reports to be created and delivered.
On the database layer of the architecture, there are several data sources you’ll have to become familiar with.
SharePoint Content Lists and Libraries
As you are probably aware, SharePoint stores its web site contents in content databases. These databases contain
the site collections, sites, lists, libraries, and pages that make up the sites served by SharePoint. In the context of
PerformancePoint, most of the business intelligence objects, including the dashboards themselves, are also stored
in lists and libraries within SharePoint’s content databases.
PerformancePoint Service Databases
Like the other service applications in SharePoint Server 2013, PerformancePoint Services needs to store data that
does not fit well into the usual format of lists and libraries in SharePoint. This data is stored in a separate database
that’s created when a new instance of the PerformancePoint service application is created. The tables in this database,
like all SharePoint databases, should never be manipulated directly but only through PerformancePoint Services.
These tables contain various parameters used by PerformancePoint Services (PPS), as well as dashboard annotations
and comments entered by users.
SQL Server Analysis Services (SSAS) Cubes
Because of the types of analysis normally performed with PerformancePoint Services, perhaps the most common
data source for key performance indicators (KPIs), scorecards, and dashboards is SQL Server Analysis Services (SSAS).
The cubes stored in SSAS contain the raw business information that PPS will “slice and dice” to perform the analysis
required by the user. For a full description of using SSAS cubes to store and manipulate multidimensional data,
see Chapter 1.
Other Reporting Data Sources
While SQL Analysis Services is the most common source of information for PPS dashboards, it is far from the only
option. Any data store from which you can read data is a potential data source for PerformancePoint. Additional data
sources supported out of the box include SQL Server relational tables, Excel spreadsheets (either file-based or via
Excel Services), and SharePoint lists.
With a little more effort, you can expand the available data sources to include any Open Database Connectivity
(ODBC) - compliant relational database and even data accessed via custom code written and deployed by the
user’s organization. For details on creating custom data source providers for PerformancePoint Services,
see msdn.microsoft.com/en-us/library/bb836514.aspx . To access other non-Microsoft databases, you can use
either Business Connectivity Services (discussed in Chapter 4) to expose the data as a SharePoint list or a SQL linked
server to expose the data as a SQL Server table ( msdn.microsoft.com/en-us/library/ms188279.aspx ).
Search JabSto ::