Databases Reference
In-Depth Information
You want dynamic hierarchies that refresh when the data source is updated.
■
■
You want Time Intelligence features by which you can both filter and create variations on the
filter that allow the user to select a single “current date.”
You want to create or include any of the following reports or report features in your
dashboard:
■
Note
Some reports or report features are created in Dashboard Designer, whereas others
are already created in another BI tool, such as SQL Server Reporting Services. The distinc-
tion is discussed in Chapter 8.
•
Analytic chart
•
Analytic grid
•
KPI details
•
Show details
•
Decomposition tree
•
Reporting Services report
•
ProClarity Analytics Server Page report
Use “native” dashboard tools, such as Excel Services, SharePoint dashboard pages, KPIs, and
filters, when you want to include any of the following data sources:
•
Analysis Services
•
PowerPivot
•
SQL Server
•
Excel workbook
•
Visio diagram
■
The BI reports or logic are already based in Excel (often the case, given Excel's widespread
usage).
■
■
The needs around your KPIs are fairly simple and don't have more than a few states (up to five
states).
You need KPIs on a page or series of pages, have very simple KPI needs, and don't want to
spend the time creating and managing more complex solutions such as a PerformancePoint
scorecard or workbook file.
■
Search WWH ::
Custom Search