Database Reference
In-Depth Information
data sources work best with PerformancePoint when organized in a way that
distinguishes columns as either dimension data or fact (measure) data by the
PerformancePoint Dashboard Designer during data import. One example of
this organization is that a column within a spreadsheet that should contain
fact (measure) data must contain only numeric values in order to be classified
as a fact source by the Dashboard Designer.
Multidimensional data sources are those that include dimensions, measures
(facts), and support—either the MDX or DMX language. PerformancePoint mul-
tidimensional data sources presently include Analysis Services and PowerPivot
workbooks.
Key usage differences exist among the tabular and multidimensional data
source capabilities within PerformancePoint. A key limitation found when using
a tabular data source is that data is flattened, so it cannot represent parent/
child relationships nor can it model hierarchies between dimensional values.
Additionally, tabular sources cannot be used by analytic charts and grids.
The data exploration feature, Decomposition Trees, is also not supported for
tabular data sources.
RequIReMenTS FoR RunnIng
PeRFoRMAnCePoInT
This section discusses the various hardware and software requirements for
running PerformancePoint and the Dashboard Designer.
The Dashboard Designer, used to create and organize PerformancePoint objects
into dashboards, requires a computer having a dual core, 32-bit processor with
2GB of memory and 2GB of disk space. Additionally, a SharePoint-supported
browser is required (details are provided in the “SharePoint Requirements”
section that follows.
Analysis Services 2000 is no longer being supported as a data source and,
along with SharePoint, PerformancePoint requires 64-bit server architecture.
SHArEPoINT rEQuIrEMENTS
To install, configure, and run SharePoint web servers and application servers,
the host server must have a 4 core 64-bit processor with 8GB of memory and
