Microsoft Office Tutorials and References
In Depth Information
The first components to be created in a PerformancePoint solution are data sources. These define the locations and
parameters to use when accessing the data that will be used by the dashboard. PerformancePoint supports two major
categories of data sources: tabular list and SSAS BISM Models (Tabular and Multidimensional). More details on
Tabular and Multidimensional model can be found at http://msdn.microsoft.com/en-us/library/hh212940.aspx .
Tabular List data sources are those that provide PPS with a relational table of data to work with. It is important
not to confuse this with the Tabular Model. The most commonly used data sources of this type are SQL Server tables.
Other options include cells retrieved from Excel spreadsheets, either through Excel Services or directly from a file,
or the items in a SharePoint list. It is also possible to use SharePoint’s Business Connectivity Services (BCS) or
SQL linked servers to pass data from other relational database management system (RDBMS) or line-of-business
applications into a PerformancePoint dashboard.
Multidimensional data sources are the most common type used in PerformancePoint solutions. They use SQL
Server Analysis Services (SSAS) cubes to furnish and process data. Analysis Services is the only currently supported
OLAP data source.
Filters are components that let users select parts of the data set to examine while excluding the rest. For example,
you can use a filter to examine data only for certain time periods, as Figure 6-7 shows.
Figure 6-7. A multi-selectable member-selection filter
In SharePoint 2013, filters allow users to search for a particular value from the text box. Filters also highlight the
items in bold font if there are any items selected in that hierarchy. This feature allows the users to identify the selected
items when the tree view is in a collapsed state.
Search JabSto ::