The Analysis Services template can connect to both Analysis Services 2000
and Analysis Services 2005. The Standard Queries category includes just a single
template to open any data source accessible via ODBC. The Tabular List category
includes four templates: one for Excel Services (the web version of Excel), one to
import data from an Excel 2007 workbook, one to import data from SharePoint
Lists, and a final template to read directly from a SQL Server table, which includes
both SQL Server 2000 and SQL Server 2005. Figure 5-3 shows all the data source
types that are included with PerformancePoint Server.
Since most business intelligence applications will be based, at least partly, on
Analysis Services cubes, this example will show you how to set up a data connection
to Analysis Services 2005. After choosing to create a new data source and selecting
Analysis Services as the template, a dialog box appears that asks for the name of the
data source, the default display folder, and whether or not to grant read permissions
to users who are authenticated to the PerformancePoint Monitoring Server. The
name should be descriptive but is not something that will be seen by end users; it is
only visible to other developers. The default display folder location is optional and
will create a folder (or use an existing one) in the Workspace Browser. The folder
mechanism allows for multiple items, in this case data sources, to be grouped into
subfolders under the folder representing the type of object.
Pages:
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137